31. Using indexes optimizes query performance.
32. A FULLTEXT index cannot be created for multiple columns.
33. The keyword used with UNION that retains duplicate rows is . . . . . . . .
34. Which is the command to move the cursor to the beginning of line in mysql input editor?
35. The number of tables for which DELAYED works is . . . . . . . .
MyISAM, MEMORY, ARCHIVE, BLACKHOLE
MyISAM, MEMORY, ARCHIVE, BLACKHOLE
36. The option that specifies the data directory location at server startup is . . . . . . . .
37. Which command is used to display all the existing tables in a database?
38. Which of these is more restrictive?
mysql_query(), mysql_real_query()
mysql_query(), mysql_real_query()
39. It is required to have an access privilege for a database before selecting it with 'USE'.
40. Which statement makes changes to the database's global attributes?
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 9
- MySQL Miscellaneous - Section 10
- MySQL Miscellaneous - Section 11