MySQL mcq questions and answers | MySQL MCQs Page-7 section-10

Section 1 Section 2 Section 3 Section 4 Section 5 Section 6 Section 7 Section 8 Section 9 Section 10 Section 11 Section 12

61.
Which operators test whether a subquery returns any rows?

A. IN and NOT IN

B. EXISTS and NOT EXISTS

C. PRESENT

D. ABSENT

Answer & Solution Discuss in Board Save for Later

62.
What is the exec_stmt_ssl written in?

A. C++

B. C

C. Python

D. Perl

Answer & Solution Discuss in Board Save for Later

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

A. STRICT_ALL_TABLES

B. ERROR_FOR_DIVISION_BY_ZERO

C. ERROR_DIVIDE_BY_ZERO

D. ERROR_WHEN_DIVIDE_BY_ZERO

Answer & Solution Discuss in Board Save for Later

64.
To execute the contents of a query file 'exec.sql' by feeding it to mysql, which command is used?

A. mysql exec.sql > sampdb

B. mysql sampdb < exec.sql

C. mysql exec.sql

D. mysql exec

Answer & Solution Discuss in Board Save for Later

65.
Which API provides the lowest level interface to the server?

A. C API

B. Perl

C. PHP

D. Python

Answer & Solution Discuss in Board Save for Later

66.
Transactional processing requires lesser overhead due to CPU cycles and memory.

A. True

B. False

Answer & Solution Discuss in Board Save for Later

67.
What will be the output of the following MySQL statement "Null OR Null"?

A. True

B. Null

C. False

D. None of the mentioned

Answer & Solution Discuss in Board Save for Later

68.
The module that links DBI to the web is . . . . . . . .

A. CGI.pn

B. CGI.pem

C. CGI.pm

D. CGI.po

Answer & Solution Discuss in Board Save for Later

69.
MEMORY tables do not support BLOB and TEXT indexes.

A. True

B. False

Answer & Solution Discuss in Board Save for Later

70.
Which of the following lines is used to turn on the event scheduler?

A. event_scheduler = ON

B. eventscheduler = ON

C. event_scheduler_ON

D. events_scheduler_ON

Answer & Solution Discuss in Board Save for Later

1 2 3 4 5 6 7 8 9 10

MySQL mcq questions and answers | MySQL MCQs

61. Which operators test whether a subquery returns any rows?

Answer & Solution

62. What is the exec_stmt_ssl written in?

Answer & Solution

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

Answer & Solution

64. To execute the contents of a query file 'exec.sql' by feeding it to mysql, which command is used?

Answer & Solution

65. Which API provides the lowest level interface to the server?

Answer & Solution

66. Transactional processing requires lesser overhead due to CPU cycles and memory.

Answer & Solution

67. What will be the output of the following MySQL statement "Null OR Null"?

Answer & Solution

68. The module that links DBI to the web is . . . . . . . .

Answer & Solution

69. MEMORY tables do not support BLOB and TEXT indexes.

Answer & Solution

70. Which of the following lines is used to turn on the event scheduler?

Answer & Solution

Read More Section(MySQL Miscellaneous)

61.
Which operators test whether a subquery returns any rows?

62.
What is the exec_stmt_ssl written in?

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

64.
To execute the contents of a query file 'exec.sql' by feeding it to mysql, which command is used?

65.
Which API provides the lowest level interface to the server?

66.
Transactional processing requires lesser overhead due to CPU cycles and memory.

67.
What will be the output of the following MySQL statement "Null OR Null"?

68.
The module that links DBI to the web is . . . . . . . .

69.
MEMORY tables do not support BLOB and TEXT indexes.

70.
Which of the following lines is used to turn on the event scheduler?