91. What is generally done if an error occurs during the transaction?
92. Which are the two languages used in Mysql?
93. On Unix, 'mysql' client writes a record of executed statements to a history file.
94. How many of the following do not return rows?
SELECT, SHOW, DESCRIBE
SELECT, SHOW, DESCRIBE
95. Which statement is used to create a trigger?
96. 'character_set_database' represents the character set used by the default database.
97. What will be the output of the following MySQL command?
SELECT *
FROM employee
WHERE title=’HEAD TELLER’;
SELECT *
FROM employee
WHERE title=’HEAD TELLER’;
98. To combine multiple retrievals, which keyword is used to write several SELECT statements between them?
99. The join in which all the rows from the right table appear in the output irrespective of the content of the other table is . . . . . . . .
100. The storage size in bytes required for the MEDIUMINT datatype 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