91. Which keyword in the UPDATE statement is used to assign values to columns?
92. Which of these has a smaller memory footprint?
Perl, PHP
Perl, PHP
93. Which keyword is used to create a database?
94. Before relocation of database, the server should be stopped if running.
95. What is abc in the following SQL statement?
DELETE FROM xyz WHERE abc = 5;
DELETE FROM xyz WHERE abc = 5;
96. Which mode tells the server to recognize double quote as an identifier quoting character?
97. What is abc in the following MySQL statement?
CREATE TRIGGER abc (...) (...) ON def FOR EACH ROW ghi;
CREATE TRIGGER abc (...) (...) ON def FOR EACH ROW ghi;
98. When linking to a static MySQL C client library, the client library and the client application can use different compiler options.
99. To perform a delete on a single-table, how is the name of a column qualified?
100. For which of the following are triggers not supported?
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 11
- MySQL Miscellaneous - Section 12