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

Database & Table

Database, Column & New Update

Table, Column & New Data

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

exit

stop

quit

done

over

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

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

Operator

Data Type

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

True

False

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

Yes

No

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

Operator

Data Type

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

Clay tiles!

Porcelain tiles!

Ceramic tiles!

Reptiles!

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

Daisies!

Roses!

Tulips!

Chrysanthemums!

Irises!

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. What is a database?

a web host

an operating system

an interpreter

a programming language

a stored collection of information

10. What will "DESCRIBE columnname;" do?

Show All the Columns In A Table

Show All the Tables In A Column

Nothing

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

CREATE TABLE columnnames (tablename);

CREATE tablename (columnnames);

CREATE columnnames (tablename);

CREATE TABLE tablename (columnnames);

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

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

;

:

'

-

#