51. The escape sequence for carriage return is . . . . . . . .
52. Loading is faster when a table has no indexes than when it is indexed.
53. The datatype that means a variable length non binary string is . . . . . . . .
54. What will be the output of the following MySQL command?
SELECT emp_id, fname, lname
FROM employee
WHERE title=’HEAD TELLER’ AND start_date=2008-11-24;
SELECT emp_id, fname, lname
FROM employee
WHERE title=’HEAD TELLER’ AND start_date=2008-11-24;55. There cannot be more than one column per table with the AUTO_INCREMENT attribute.
56. What is abc in the following MySQL statement?
DECLARE abc HANDLER FOR def ghi;
DECLARE abc HANDLER FOR def ghi;57. Usage of aggregates in WHERE clause is allowed.
58. Which of these operators perform similar operations like ALL and ANY?
59. Suppose it is desired that UNION operation should return not more than 3 rows. Which keyword is used for this?
60. What is ghi in the following MySQL statement?
CREATE TRIGGER abc (...) (...) ON def FOR EACH ROW ghi;
CREATE TRIGGER abc (...) (...) ON def FOR EACH ROW ghi;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 7
- MySQL Miscellaneous - Section 8
- MySQL Miscellaneous - Section 9
- MySQL Miscellaneous - Section 10
- MySQL Miscellaneous - Section 11
- MySQL Miscellaneous - Section 12