71. In the following SQL query, what does "person" stands for?
INSERT INTO person
(person_id, fname, lname)
VALUES (1,’S’,’P’);
INSERT INTO person
(person_id, fname, lname)
VALUES (1,’S’,’P’);
72. '2341' is a . . . . . . . .
73. What cannot be done on a view?
74. What will be the output of the following MySQL statement?
SELECT account_id, product_id, cust_id
FROM account
WHERE product_id NOT IN (‘sav’, ‘chd’, ‘mm’);
SELECT account_id, product_id, cust_id
FROM account
WHERE product_id NOT IN (‘sav’, ‘chd’, ‘mm’);
75. How many values can be returned from a given stored function?
76. Which value of event_scheduler enables checking status but not changing it at runtime?
77. What is the default format for "Datetime" data type?
78. Which Clause is used to select a particular table in Mysql?
79. Which authentications are required for login into Mysql command line tool?
80. How many options can be used to control LOCAL capability at runtime?
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 10
- MySQL Miscellaneous - Section 11