Login | Contact Us | Site Map | Resources

MYSQL Quiz

Log in before taking this test if you want your score to be saved in order to receive a certification of achievement. If you are not yet a member, you can register free of charge.

1. Is it possible to change the format of a table that already contains data?

Yes

No


2. Which of the following syntax examples will cause an error?

SELECT column1, column2, column2 FROM tablename;

SELECT * FROM tablename WHERE columnname LIKE '%keyword%';

SELECT * FROM tablename WHERE (column1 LIKE 'keyword' AND column2 LIKE 'keyword';

SELECT DISTINCT column1 FROM tablename ORDER BY column1;

SELECT * FROM pets COUNT(*);


3. MYSQL is the opposite of an Excel spreadsheet or HTML table.

True

False


Bonus Question: What kind of tiles can't you stick on walls?

Clay tiles!

Porcelain tiles!

Ceramic tiles!

Reptiles!


4. What is the proper syntax for creating a table?

CREATE TABLE columnnames (tablename);

CREATE tablename (columnnames);

CREATE columnnames (tablename);

CREATE TABLE tablename (columnnames);


Bonus Question: What kind of flower grows on your face?

Daisies!

Roses!

Tulips!

Chrysanthemums!

Irises!


5. What is the proper syntax used to insert data into a table?

INSERT INTO tablename VALUES ();

INSERT VALUES () INTO tablename ();

INSERT VALUES () INTO tablename;

INSERT INTO tablename () VALUES ();


6. What is the proper syntax for deleting a table?

DELETE DATABASE IF EXISTS databasename;

DROP TABLE tablename;

DELETE TABLE tablename;

DROP DATABASE IF EXISTS databasename;


7. What is a database?

a web host

an operating system

an interpreter

a programming language

a stored collection of information


8. Is "=" an operator or a data type?

Operator

Data Type


9. Which character is used to indicate the end of a MYSQL statements?

;

:

'

-

#


10. What 3 things need to be specified during an UPDATE statement?

Database & Table

Database, Column & New Update

Table, Column & New Data


11. What will "DESCRIBE columnname;" do?

Show All the Columns In A Table

Show All the Tables In A Column

Nothing


12. Which command will disconnect you from the mysql server?

exit

stop

quit

done

over


13. Is "INT" an operator or a data type?

Operator

Data Type