MySQL mcq questions and answers | MySQL MCQs

Home / MySQL / MySQL Miscellaneous

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’)

Answer & Solution Discuss in Board Save for Later

92.
How many among the following use NULL to indicate failure?
mysql_init(), mysql_real_connect()

Answer & Solution Discuss in Board Save for Later

93.
To minimize disk I/O, which of these should be chosen?
CHAR, VARCHAR

Answer & Solution Discuss in Board Save for Later

94.
The statement to remove indexes on tables is . . . . . . . .

Answer & Solution Discuss in Board Save for Later

95.
Arrays cannot have associative indices in PHP.

Answer & Solution Discuss in Board Save for Later

96.
Which keyword suppresses errors?

Answer & Solution Discuss in Board Save for Later

97.
Which declaration doesn't use the same number of bytes and consumption of bytes depends on the input data?

Answer & Solution Discuss in Board Save for Later

98.
The option that is necessary to compile a C program having math functions is . . . . . . . .

Answer & Solution Discuss in Board Save for Later

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);

Answer & Solution Discuss in Board Save for Later

100.
For a heavily used program, which of these languages should be preferred?

Answer & Solution Discuss in Board Save for Later

Read More Section(MySQL Miscellaneous)

Each Section contains maximum 100 MCQs question on MySQL Miscellaneous. To get more questions visit other sections.