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;
DELETE FROM x USING x LEFT JOIN y ON x.col = y.col;
9. How many of the following can be used in stored procedures?
PREPARE, EXECUTE, DEALLOCATE PREPARE
PREPARE, EXECUTE, DEALLOCATE PREPARE
10. The default value in seconds in the system variable 'long_query_time' is . . . . . . . .
Read More Section(MySQL Miscellaneous)
Each Section contains maximum 100 MCQs question on MySQL Miscellaneous. To get more questions visit other sections.
- MySQL Miscellaneous - Section 1
- MySQL Miscellaneous - Section 2
- MySQL Miscellaneous - Section 3
- MySQL Miscellaneous - Section 4
- MySQL Miscellaneous - Section 5
- MySQL Miscellaneous - Section 6
- MySQL Miscellaneous - Section 7
- MySQL Miscellaneous - Section 8
- MySQL Miscellaneous - Section 10
- MySQL Miscellaneous - Section 11
- MySQL Miscellaneous - Section 12