71. In which mode is the indicator of the presence/absence of a word in search used?
72. The column not returned by 'OPTIMIZE TABLE' is . . . . . . . .
73. If emp_id contain the following set {9, 7, 6, 4, 3, 1, 2}, what will be the output on execution of the following MySQL command?
SELECT emp_id
FROM person
ORDER BY emp_id DESC;
SELECT emp_id
FROM person
ORDER BY emp_id DESC;
74. MySQL provides a date type that has an optional time part.
75. There is a startup penalty for a standalone interpreter.
76. "CREATE TABLE ..." command is used to create which type of table in Mysql?
77. What sets the association between one or more MyISAM tables and the named key cache?
78. The one that is more restrictive is . . . . . . . .
mysql_query(), mysql_real_query()
mysql_query(), mysql_real_query()
79. The keyword used with UNION that retains duplicate rows is . . . . . . . .
80. What is 'xyz' in the following SQL statement?
SELECT abc FROM xyz;
SELECT abc FROM xyz;
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