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. Which command will disconnect you from the mysql server?

exit

stop

quit

done

over


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

Database & Table

Database, Column & New Update

Table, Column & New Data


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

Clay tiles!

Porcelain tiles!

Ceramic tiles!

Reptiles!


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

True

False


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

CREATE TABLE columnnames (tablename);

CREATE tablename (columnnames);

CREATE columnnames (tablename);

CREATE TABLE tablename (columnnames);


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

;

:

'

-

#


6. What is a database?

a web host

an operating system

an interpreter

a programming language

a stored collection of information


7. 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(*);


8. 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 ();


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

Operator

Data Type


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

Operator

Data Type


11. What will "DESCRIBE columnname;" do?

Show All the Columns In A Table

Show All the Tables In A Column

Nothing


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

Daisies!

Roses!

Tulips!

Chrysanthemums!

Irises!


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

Yes

No


13. 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;