11. In the following MySQL command how many rows will be deleted?
DELETE person
WHERE person_id=1;
/*person_id is a primary key */
DELETE person
WHERE person_id=1;
/*person_id is a primary key */
12. Which type stores the longest length of strings?
13. x'ffff' in decimal is . . . . . . . .
14. What is def in the following MySQL statement?
CREATE TRIGGER abc (...) (...) ON def FOR EACH ROW ghi;
CREATE TRIGGER abc (...) (...) ON def FOR EACH ROW ghi;
15. Which statement is used to determine the storage engine for individual tables?
16. The MySQL server is highly configurable.
17. How many of the following does not return a value?
mysql_close(), mysql_init, mysql_real_connect
mysql_close(), mysql_init, mysql_real_connect
18. The indicator of presence/absence of a word in search is used in the mode . . . . . . . .
19. What is the hub of a MySQL installation?
20. Which among the following is the correct representation of "float(5,0)"?
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