91. Which of the following clauses is used to display information that match a given pattern?
92. Which data directory subdirectory corresponds to the nbdinfo database?
93. Which data type is more suitable for storing "small notes" in Mysql?
94. The maximum length of the char columns is . . . . . . . .
95. For a table having 4 columns, the number of columns to which hash function is applied when using hash indexes is . . . . . . . .
96. 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 ASC;
SELECT emp_id
FROM person
ORDER BY emp_id ASC;97. What will be the output of the following MySQL command?
SELECT *
FROM person
WHERE emp_id IS NULL;
SELECT *
FROM person
WHERE emp_id IS NULL;98. Which clause in the SQL standard controls how NULL values in a composite foreign key are handled when comparing to a primary key.
99. Which option is used in mysqldump to make all tables in the destination databases to use a different storage engine?
100. Which option repairs MyISAM tables automatically after they open?
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 6
- MySQL Miscellaneous - Section 7
- MySQL Miscellaneous - Section 8
- MySQL Miscellaneous - Section 9
- MySQL Miscellaneous - Section 10
- MySQL Miscellaneous - Section 11
- MySQL Miscellaneous - Section 12