MySQL Practice Test 7

1. The error log file has a suffix ______________

2. Which mode exists at both global level and session-specific level?

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

4. MySQL supports shared-memory connections on Windows.

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

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

7. What is the statement used to select a default database?

8. The keyword used with UNION that does not retain duplicate rows is _____________

9. The log that identifies statements that may be in need of being rewritten for better performance is ______________

10. What is the precision of BIGINT?