MySQL Practice Test 1

1. Which keyword is used to create a table as a temporary copy of itself?

2. Which of the following commands sets the SQL mode as TRADITIONAL?

3. The statement to change the table name is __________

4. MySQL stores the database character set and collation attributes in the file _________

5. In UNIX, the name of the option file is __________

6. Regardless of whether a database or table name is case sensitive on the system, it must be referred to using the same lettercase throughout a given query.

7. The clause that filters JOIN results is called _________

8. To create a database only if it doesn't already exist, which clause is used?

9. What does 'abc' & 'xyz' specify in the following SQL statement?

CREATE TABLE abc (xyz);

10. The default index type for MEMORY tables is __________