91. What is the significance of "ORDER BY" in the following MySQL statement?
SELECT emp_id, fname, lname
FROM person
ORDER BY emp_id;
SELECT emp_id, fname, lname
FROM person
ORDER BY emp_id;
92. A procedure that involves REPAIR TABLE with the USE_FRM option must be done before upgrading.
93. In the following MySQL command how many rows will be updated?
UPDATE person
SET lname=’s’,
Fname = ’p’,
WHERE person_id = 1;
/* person_id is a primary key */
UPDATE person
SET lname=’s’,
Fname = ’p’,
WHERE person_id = 1;
/* person_id is a primary key */
94. Which of these operators does not perform relative value comparisons?
95. Which header should be included first?
96. In oracle database variable length column is declared by . . . . . . . .
97. What is the isolation property of transactions?
98. What is the SQL mode to check for divide by zero error?
99. What returns a string containing an error message?
100. Which of the following returns a MySQL-specific numeric code?
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