MySQL Practice Test 7

1. The command to see the warning messages is ______________

2. The number of options that can be used to control LOCAL capability at runtime is _____________

3. What does the default case sensitivity of database and table names depend on?

4. What is InnoDB in the following MySQL code?

CREATE TABLE student (
		name CHAR(30),
		student_id INT,
		PRIMARY KEY (student_id)
	) ENGINE = InnoDB;

5. A FULLTEXT index can be created for multiple columns.

6. What is the special database that always exists after setting up MySQL on a computer?

7. The variable which represents the default time zone of the MySQL server is _____________

8. A multiple-table delete cannot apply any join.

9. The name of the format file for a table named my_tbl is __________

10. The statement used to obtain access privileges to an account is ______________