11. In the following SQL command "person_id" can be . . . . . . . .
SELECT person_id, fname, lname, Birth_data FROM person WHERE person_id=1;
SELECT person_id, fname, lname, Birth_data FROM person WHERE person_id=1;
12. A binary string is not associated with a character set.
13. What will be the output of the following MySQL statement?
SELECT *
FROM employee
WHERE start_date BETWEEN ‘2007-01-01’ AND ‘2008-01-01’;
SELECT *
FROM employee
WHERE start_date BETWEEN ‘2007-01-01’ AND ‘2008-01-01’;
14. INFORMATION_SCHEMA is based on the SQL standard.
15. To maintain performance of tables having variable length rows, which statement is used?
16. Which mode tells not to cache query results?
17. What attempts auto recovery based on the contents of its serial log?
18. A multiple-table delete cannot apply any join.
19. The datadir variable value can be seen using . . . . . . . .
20. The AUTO_INCREMENT sequences normally begin at . . . . . . . .
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