71. When no modes are enabled, what does this SQL statement return?
SELECT @@SESSION.sql_mode;
SELECT @@SESSION.sql_mode;
72. What causes a replication master server to delete all the binary log files even if they are still in use?
73. Which of these can be used to generate hash values?
74. What is x in the following MySQL statement?
DELETE FROM x USING x LEFT JOIN y ON x.col = y.col;
DELETE FROM x USING x LEFT JOIN y ON x.col = y.col;
75. What is the default format for "Date" data type?
76. Which of these is a stored program associated with a schedule?
77. What is the meaning of "NULL" in Mysql?
78. The data rows of a MyISAM table are stored in . . . . . . . .
79. The statement that is used to check the status of the event scheduler at runtime is . . . . . . . .
80. The option that executes all SQL statements in a SQL script irrespective of the number of errors is . . . . . . . .
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 12