21. Which clause is used to "sort the rows of the final result set by one or more columns"?
22. Which option executes all SQL statements in a SQL script irrespective of the number of errors?
23. The name of the option file in Unix is . . . . . . . .
24. The facility that allows nesting one select statement into another is . . . . . . . .
25. Which privilege is enabled to create of alter a stored function?
26. CROSS JOIN and JOIN are similar to . . . . . . . .
27. The statement that performs key distribution analysis and stores the distribution for the named tables is . . . . . . . .
28. How many of these can replace ‘level’ in ‘-myisam-recover = level’?
BACKUP, FORCE, QUICK
BACKUP, FORCE, QUICK
29. Which option is used for specifying the executable name while compiling with gcc?
30. Which mode tells the server to recognize || as the string concatenation operator?
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