91. What will be the result of the following MySQL command?
WHERE end_date IS NULL
AND NOT (title=’teller’ OR start_date < ‘2007-01-01’)
WHERE end_date IS NULL
AND NOT (title=’teller’ OR start_date < ‘2007-01-01’)
92. How many among the following use NULL to indicate failure?
mysql_init(), mysql_real_connect()
mysql_init(), mysql_real_connect()
93. To minimize disk I/O, which of these should be chosen?
CHAR, VARCHAR
CHAR, VARCHAR
94. The statement to remove indexes on tables is . . . . . . . .
95. Arrays cannot have associative indices in PHP.
96. Which keyword suppresses errors?
97. Which declaration doesn't use the same number of bytes and consumption of bytes depends on the input data?
98. The option that is necessary to compile a C program having math functions is . . . . . . . .
99. Consider a database name "db_name" whose attributes are intern_id (primary key), subject.
Intern_id = {1, 2, 3, 4, 5, 6}
Subject = {sql, oop, sql, oop, c, c++}
If these are one to one relation then what will be the output of the following MySQL statement?
SELECT intern_id
FROM db_name
WHERE subject IN (c, c++, oop, SQL);
Intern_id = {1, 2, 3, 4, 5, 6}
Subject = {sql, oop, sql, oop, c, c++}
If these are one to one relation then what will be the output of the following MySQL statement?
SELECT intern_id
FROM db_name
WHERE subject IN (c, c++, oop, SQL);
100. For a heavily used program, which of these languages should be preferred?
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