21. Which command is used to show all tables that are stored in a database?
22. Comparing a known value with NULL results into . . . . . . . .
23. The 'SOCKET' protocol is permitted on which operating systems?
24. What is the property of InnoDB that enforces foreign key relationships stay intact?
25. The following MySQL statement is valid.
SELECT abc, xyz FROM table1 UNION abc, def FROM table2;
SELECT abc, xyz FROM table1 UNION abc, def FROM table2;
26. What is the use of "VIEW" in Mysql?
27. Suppose the last row has the AUTO_INCREMENT column value 32. Suppose a new row is added by setting AUTO_INCREMENT value equal to 100. The next row added will have value . . . . . . . .
28. Suppose run_me.sh is a script file. Which command is used to make it executable?
29. Which clause specifies periodic execution at fixed intervals?
30. There can be only one column per table with the AUTO_INCREMENT attribute.
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 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 11
- MySQL Miscellaneous - Section 12