MySQL mcq questions and answers | MySQL MCQs Page-9 section-6

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

81.
Which keyword is used to delete all the rows from the table?

A. TRUNCATE

B. REMOVE

C. DELETE ALL

D. CLEAR

Answer & Solution Discuss in Board Save for Later

82.
The 'A' in the ACID property of transactions is . . . . . . . .

A. Availability

B. Accuracy

C. Adjustability

D. Atomicity

Answer & Solution Discuss in Board Save for Later

83.
The recovery of data changes made since a given point in time is called . . . . . . . .

A. decremental

B. incremental

C. close

D. clear

Answer & Solution Discuss in Board Save for Later

84.
What is the Perl DBI?

A. database inheritance

B. database integrity

C. database interface

D. database isolation

Answer & Solution Discuss in Board Save for Later

85.
The indicator of presence or absence of a word in search is used in which mode?

A. Natural language

B. Boolean mode

C. Query expansion

D. Cross mode

Answer & Solution Discuss in Board Save for Later

86.
TO enable the compressed client/server protocol the option is . . . . . . . .

A. -enable

B. -compress

C. -reduce

D. -restrict

Answer & Solution Discuss in Board Save for Later

87.
Increasing the value of 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

88.
Which mode exists at both global level and session-specific level?

A. sql_mode

B. key_buffer_size

C. server_mode

D. query_mode

Answer & Solution Discuss in Board Save for Later

89.
PHP scripts are located in the web client document tree.

A. True

B. False

Answer & Solution Discuss in Board Save for Later

90.
Multiple statement execution is disabled by default.

A. True

B. False

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

81. Which keyword is used to delete all the rows from the table?

Answer & Solution

82. The 'A' in the ACID property of transactions is . . . . . . . .

Answer & Solution

83. The recovery of data changes made since a given point in time is called . . . . . . . .

Answer & Solution

84. What is the Perl DBI?

Answer & Solution

85. The indicator of presence or absence of a word in search is used in which mode?

Answer & Solution

86. TO enable the compressed client/server protocol the option is . . . . . . . .

Answer & Solution

87. Increasing the value of which system variable enables mysqld to keep more tables open simultaneously?

Answer & Solution

88. Which mode exists at both global level and session-specific level?

Answer & Solution

89. PHP scripts are located in the web client document tree.

Answer & Solution

90. Multiple statement execution is disabled by default.

Answer & Solution

Read More Section(MySQL Miscellaneous)

81.
Which keyword is used to delete all the rows from the table?

82.
The 'A' in the ACID property of transactions is . . . . . . . .

83.
The recovery of data changes made since a given point in time is called . . . . . . . .

84.
What is the Perl DBI?

85.
The indicator of presence or absence of a word in search is used in which mode?

86.
TO enable the compressed client/server protocol the option is . . . . . . . .

87.
Increasing the value of which system variable enables mysqld to keep more tables open simultaneously?

88.
Which mode exists at both global level and session-specific level?

89.
PHP scripts are located in the web client document tree.

90.
Multiple statement execution is disabled by default.