11. What can be used to check for views that have been invalidated by DROP or ALTER operations?
12. What will be the output of the following MySQL command?
SELECT *
FROM person
WHERE emp_id = NULL;
SELECT *
FROM person
WHERE emp_id = NULL;13. The maximum collations a character set can have is . . . . . . . .
14. Which option is necessary to compile a C program havin math functions?
15. What will be the output of the following MySQL statement?
SELECT emp_id, fname, lname
FROM employee
WHERE LEFT (fname, 1) =’F’;
SELECT emp_id, fname, lname
FROM employee
WHERE LEFT (fname, 1) =’F’;16. How many of the following shared tablespaces is bound by the OS file size limit?
MyISAM, InnoDB, TRANSACTION
MyISAM, InnoDB, TRANSACTION17. The command which lists databases managed by the server is . . . . . . . .
18. What default value gets stored in columns of the table?
19. Which among the following tags belong to Data Manipulation language?
20. Triggers enable to enforce data integrity constraints.
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