61. The library file that contains various portability macros and definitions is . . . . . . . .
62. The most restrictive among the following is . . . . . . . .
mysql_query(), mysql_real_query()
mysql_query(), mysql_real_query()
63. The largest value to which the variable 'max_allowed_packet' can be set is . . . . . . . .
64. User defined variables are session specific.
65. For which table does 'REPAIR TABLE' not work?
66. The maximum number of elements allowed in SET() is . . . . . . . .
67. What is the significance of "ORDER BY emp_id DESC" in the following MySQL command?
SELECT emp_id, fname, lname
FROM person
ORDER BY emp_id DESC;
SELECT emp_id, fname, lname
FROM person
ORDER BY emp_id DESC;
68. What has a higher priority?
writes, reads
writes, reads
69. X'61626364' and X'61626364' are respectively . . . . . . . .
70. Will the following SQL command produce any error?
INSERT INTO person
(person_id, fname,lname)
VALUES (1,’S’,’U’),
VALUES (2,’T’,’U’);
/* where person_id is a primary key */
INSERT INTO person
(person_id, fname,lname)
VALUES (1,’S’,’U’),
VALUES (2,’T’,’U’);
/* where person_id is a primary key */
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 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
- MySQL Miscellaneous - Section 12