Explore topic-wise MCQs in Mysql.

This section includes 8 Mcqs, each offering curated multiple-choice questions to sharpen your Mysql knowledge and support exam preparation. Choose a topic below to get started.

1.

How many of the following use NULL to indicate failure?
mysql_init(), mysql_real_connect()
A. 3
B. 2
C. 1
D. 0
E. None of these
Answer» C. 1
Discussion
2.

How many of the following does not return a value?
mysql_close(), mysql_init, mysql_real_connect
A. 3
B. 2
C. 1
D. 0
E. None of these
Answer» D. 0
Discussion
3.

The protocol value TCP runs on which operating systems?

A. windows only
B. all
C. unix only
D. mac
E. None of these
Answer» C. unix only
Discussion
4.

The argument to the function mysql_error() is _______________.

A. pointer
B. structure
C. float
D. integer
E. None of these
Answer» B. structure
Discussion
5.

The SQL mode to check for divide by zero error is ________________.

A. ERROR_DIVIDE_BY_ZERO
B. ERROR_WHEN_DIVIDE_BY_ZERO
C. ERROR_FOR_DIVISION_BY_ZERO
D. STRICT_ALL_TABLES
E. None of these
Answer» D. STRICT_ALL_TABLES
Discussion
6.

For which type are illegal values converted to the appropriate zero value?

A. TIME
B. ENUM
C. String
D. Numeric
E. None of these
Answer» B. ENUM
Discussion
7.

Which mode prevents entry of the zero date value in strict mode?

A. NO_ZERO_IN_DATE
B. PREVENT
C. SUPPRESS
D. NO_ZERO_DATE
E. None of these
Answer» E. None of these
Discussion
8.

Which mode is a shorthand for both strict modes plus a bunch of other restrictions ?

A. TRADITIONAL
B. ERROR_WHEN_DIVIDE_BY_ZERO
C. STRICT_TRANS_TABLES
D. STRICT_ALL_TABLES
E. None of these
Answer» B. ERROR_WHEN_DIVIDE_BY_ZERO
Discussion