51. What is the size of the BIT type?
52. Without LOCAL, LOAD DATA is . . . . . . . .
53. The variable used to set table alias names as non case sensitive is . . . . . . . .
54. MySQL Enterprise Backup records details of each backup in . . . . . . . .
55. Which data type is best suited to store currency values?
56. The maximum size in bytes of a row in MySQL is . . . . . . . .
57. Foreign keys cannot handle deletes and updates.
58. Which of the following commands sets the SQL mode as TRADITIONAL?
59. Is there any error in the following MySQL statement?
SELECT e.emp_id, e.fname,e.lname,d.name
FROM employee AS e INNER JOIN department AS d
ON e.dept_id=e.dept_id;
SELECT e.emp_id, e.fname,e.lname,d.name
FROM employee AS e INNER JOIN department AS d
ON e.dept_id=e.dept_id;60. What will be the output of the following MySQL command?
SELECT *
FROM employee
WHERE (title=’HEAD TELLER’) AND (start_date>2013-01-24);
SELECT *
FROM employee
WHERE (title=’HEAD TELLER’) AND (start_date>2013-01-24);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