31. CHECK TABLE works with how many of the following?
MyISAM, ARCHIVE, CSV
MyISAM, ARCHIVE, CSV32. Stored programs improve database security.
33. Which is the join in which all the rows from the right table appear in the output irrespective of the content of the other table?
34. What is the special database that always exists after setting up MySQL on a computer?
35. What is the general term for information about databases and the objects in MySQL?
36. Multiple statement execution is enabled by default.
37. The expression 12 DIV 5 evaluates to . . . . . . . .
38. Calculations involving numbers are faster than those involving string.
39. To combine multiple retrievals, we write several SELECT statements and put the keyword between them. What is the keyword?
40. If attribute "fruit" stores data as "apple, mango, banana" in table person then what will be the output of the following SQL command?
SELECT fruit FROM person
WHERE person_id=1
ORDER BY fruit;
SELECT fruit FROM person
WHERE person_id=1
ORDER BY fruit;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