MySQL Practice Test 9

1. “CREATE TABLE …” command is used to create which type of table in Mysql?

2. What will be the output of the following SQL statement?

SELECT  * FROM person
WHERE person_id=1;

3. Which system variable when set to 1, makes all temporary tables to get stored on disk rather than in memory?

4. What will be the output of the following SQL statement?

SELECT *
 FROM person;

5. MySQL does not automatically convert a date or time value to a number if the value is used in a numeric context.

6. The Audit_log_events system variable is of type _____________

7. The functions in Perl DBI called?

8. What is preferred when stored procedures are not being used?

	CLIENT_MULTI_STATEMENTS, mysql_set_server_option()

9. MySQL automatically converts a date or time value to a number if the value is used in a numeric context.

10. How can we define the clause “FROM” in Mysql?