21. The storage engine in MySQL that provides foreign key support is . . . . . . . .
22. What will be the output of the following MySQL command?
SELECT *
FROM employee
WHERE (title=’HEAD TELLER’) OR (start_date=2013-01-24);
SELECT *
FROM employee
WHERE (title=’HEAD TELLER’) OR (start_date=2013-01-24);23. The generic handle whose meaning depends on context is . . . . . . . .
24. What is preferred when stored procedures are not being used?
CLIENT_MULTI_STATEMENTS, mysql_set_server_option()
CLIENT_MULTI_STATEMENTS, mysql_set_server_option()25. In PHP, which operator is used to access property of an object?
26. What does the AUTO_INCREMENT sequences normally begin at?
27. To perform analysis of key values by the server, the statement used is . . . . . . . .
28. What does mysql_init() return?
29. What is SBR replication?
30. Slow shutdown can be performed by setting innodb_fast_shutdown to . . . . . . . .
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 7
- MySQL Miscellaneous - Section 8
- MySQL Miscellaneous - Section 9
- MySQL Miscellaneous - Section 10
- MySQL Miscellaneous - Section 11
- MySQL Miscellaneous - Section 12