MySQL mcq questions and answers | MySQL MCQs

Home / MySQL / MySQL Miscellaneous

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

71.
Converting a client/server application to embedded server is simpler.

A. True

B. False

Answer & Solution Discuss in Board Save for Later

72.
The system variable to maintain InnoDB log buffer size is . . . . . . . .

A. innodb_log_buffer_size

B. innodb_buffer_log_size

C. buffer_log_innodb_size

D. log_buffer_innodb_size

Answer & Solution Discuss in Board Save for Later

73.
The AUTO_INCREMENT column attribute is best used with . . . . . . . .

A. FLOAT

B. INT

C. CHARACTER

D. DOUBLE

Answer & Solution Discuss in Board Save for Later

74.
How do the STRICT_ALL_TABLES and STRICT_TRANS_TABLES mode values deal with bad data?

A. reject them

B. accept them

C. change them to the closest legal value and accept

D. change them to the closest legal value and reject

Answer & Solution Discuss in Board Save for Later

75.
Which of the following is the correct order of precedence (high to low)?

A. !, ^, <<, XOR

B. ^, !, <<, XOR

C. !, <<, XOR, ^

D. !, ^, XOR, <<

Answer & Solution Discuss in Board Save for Later

76.
Is it necessary to insert the value in each column of the table?

A. Yes

B. No

C. Depends on the server

D. Depends on the usage of the table

Answer & Solution Discuss in Board Save for Later

77.
Issuing 'SELECT' on a MERGE table is like . . . . . . . .

A. UNION

B. UNION ALL

C. UNION DISTINCT

D. JOIN

Answer & Solution Discuss in Board Save for Later

78.
The JDBI interface is available for . . . . . . . .

A. C

B. C++

C. Python

D. Java

Answer & Solution Discuss in Board Save for Later

79.
Which system variable enables mysqld to keep more tables open simultaneously?

A. table_cache

B. max_connect

C. delayed_queue_size

D. max_allowed_packet

Answer & Solution Discuss in Board Save for Later

80.
The synonym for last_insert_id session variable is . . . . . . . .

A. insert_id

B. identity

C. sql_auto_is_null

D. sql_big_selects

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

71. Converting a client/server application to embedded server is simpler.

Answer & Solution

72. The system variable to maintain InnoDB log buffer size is . . . . . . . .

Answer & Solution

73. The AUTO_INCREMENT column attribute is best used with . . . . . . . .

Answer & Solution

74. How do the STRICT_ALL_TABLES and STRICT_TRANS_TABLES mode values deal with bad data?

Answer & Solution

75. Which of the following is the correct order of precedence (high to low)?

Answer & Solution

76. Is it necessary to insert the value in each column of the table?

Answer & Solution

77. Issuing 'SELECT' on a MERGE table is like . . . . . . . .

Answer & Solution

78. The JDBI interface is available for . . . . . . . .

Answer & Solution

79. Which system variable enables mysqld to keep more tables open simultaneously?

Answer & Solution

80. The synonym for last_insert_id session variable is . . . . . . . .

Answer & Solution

Read More Section(MySQL Miscellaneous)

71.
Converting a client/server application to embedded server is simpler.

72.
The system variable to maintain InnoDB log buffer size is . . . . . . . .

73.
The AUTO_INCREMENT column attribute is best used with . . . . . . . .

74.
How do the STRICT_ALL_TABLES and STRICT_TRANS_TABLES mode values deal with bad data?

75.
Which of the following is the correct order of precedence (high to low)?

76.
Is it necessary to insert the value in each column of the table?

77.
Issuing 'SELECT' on a MERGE table is like . . . . . . . .

78.
The JDBI interface is available for . . . . . . . .

79.
Which system variable enables mysqld to keep more tables open simultaneously?

80.
The synonym for last_insert_id session variable is . . . . . . . .