MySQL

What is the proper syntax for deleting a table?

Select one:

a.

DELETE DATABASE IF EXISTS databasename;

b.

DROP TABLE tablename;

c.

DELETE TABLE tablename;

d.

DROP DATABASE IF EXISTS databasename;

Question 2

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

Select one:

a.

Yes

b.

No

Question 3

Which command will disconnect you from the mysql server?

Select one:

a.

exit

b.

stop

c.

quit

d.

done

e.

over

Question 4

What is a database?

Select one:

a.

a web host

b.

an operating system

c.

an interpreter

d.

a programming language

e.

a stored collection of information

Question 5

What will "DESCRIBE columnname;" do?

Select one:

a.

Show All the Columns In A Table

b.

Show All the Tables In A Column

c.

Nothing

Question 6

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

Select one:

a.

Database & Table

b.

Database, Column & New Update

c.

Table, Column & New Data

Question 7

Is "=" an operator or a data type?

Select one:

a.

Operator

b.

Data Type

Question 8

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

Select one:

a.

INSERT INTO tablename VALUES ();

b.

INSERT VALUES () INTO tablename ();

c.

INSERT VALUES () INTO tablename;

d.

INSERT INTO tablename () VALUES ();

Question 9

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

Select one:

a.

;

b.

:

c.

'

d.

-

e.

#

Question 10

Which of the following syntax examples will cause an error?

Select one:

a.

SELECT column1, column2, column2 FROM tablename;

b.

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

c.

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

d.

SELECT DISTINCT column1 FROM tablename ORDER BY column1;

e.

SELECT * FROM pets COUNT(*);