91. Which mode prevents entry of the 'zero' date value in strict mode?
92. For what can the FULLTEXT indexes be created for?
93. For InnoDB tables in mysqldump an online backup that takes no locks on tables can be performed by which option?
94. The option which finds the startup options supported by the server through mysqld is . . . . . . . .
95. The 'C' in the ACID property of transactions is . . . . . . . .
96. Foreign keys can handle deletes and updates.
97. Which of the following is more efficient?
LOAD DATA, INSERT
LOAD DATA, INSERT
98. What will be the output of of the following SQL statement?
SELECT person_id, Fname, lname
FROM person;
SELECT person_id, Fname, lname
FROM person;
99. Which collations does this MySQL statement list?
SHOW COLLATION LIKE 'utf8%'
SHOW COLLATION LIKE 'utf8%'
100. "INSERT" is same as "UPDATE"?
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 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
- MySQL Miscellaneous - Section 12