1.
Which statement can be used to specify the sql_mode system variable at runtime?

2.
What does 'abc' || 'xyz' result in if the PIPES_AS_CONCAT is disabled?

3.
The clause that enables mapping a short command to a long command is . . . . . . . .

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

5.
What does mysql_fetch_row() return?

6.
What does a fully qualified table name consist of?

7.
A DEFAULT value cannot be supplied to spatial types.

8.
'x' in the following MySQL statement is . . . . . . . .
DELETE FROM x USING x LEFT JOIN y ON x.col = y.col;

10.
The default value in seconds in the system variable 'long_query_time' is . . . . . . . .