1. Which statement issues a lock on tables?
2. Which mode is used to turn on strict mode and all of the additional restrictions?
3. The number of rows in the table is 10. Suppose all rows are deleted. The new row starts with sequence number . . . . . . . .
4. The DECIMAL used for expressions containing only exact values with fractional part is of digit precision . . . . . . . .
5. INFORMATION_SCHEMA is more portable than SHOW statements.
6. What are the results of the following SQL commands if col is an integer column?
1. SELECT * FROM mytbl WHERE num_col = '4';
2. SELECT * FROM mytbl WHERE num_col = 4;
1. SELECT * FROM mytbl WHERE num_col = '4';
2. SELECT * FROM mytbl WHERE num_col = 4;7. What can be used as an alternative to mysqlconfig?
8. The event scheduler does not run by default.
9. What is xyz in the following SQL statement?
DELETE FROM xyz WHERE abc = 5;
DELETE FROM xyz WHERE abc = 5;10. Which flag is used to compile client programs that use MySQL header files?
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