1. The best datatype for a column that is expected to store values up to 2 million is . . . . . . . .
2. What will be the result of the following MySQL command?
WHERE TITLE=’teller’ OR start_date=’2007-01-01’
WHERE TITLE=’teller’ OR start_date=’2007-01-01’
3. If emp_id contain the following set {1, 2, 2, 3, 3, 1}, what will be the output on execution of the following MySQL statement?
SELECT emp_id
FROM person
ORDER BY emp_id;
SELECT emp_id
FROM person
ORDER BY emp_id;
4. The 'LAST_INSERT_ID()' is tied only to the 'AUTO_INCREMENT' values generated during the current connection to the server.
5. The MySQL server is poorly configurable.
6. The AUTO_INCREMENT column attribute is best used with which type?
7. The metadata log is . . . . . . . .
8. In MyISAM tables, when a table is emptied with the TRUNCATE TABLE, the counter begins at . . . . . . . .
9. Which is the MySQL instance responsible for data processing?
10. Which file can be used to execute multiple compile statements?
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 8
- MySQL Miscellaneous - Section 9
- MySQL Miscellaneous - Section 10
- MySQL Miscellaneous - Section 11
- MySQL Miscellaneous - Section 12