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

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

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

A. SUPPRESS

B. NO_ZERO_DATE

C. PREVENT

D. NO_ZERO_IN_DATE

Answer & Solution Discuss in Board Save for Later

92.
For what can the FULLTEXT indexes be created for?

A. MyISAM

B. InnoDB

C. MEMORY

D. TRANSITION

Answer & Solution Discuss in Board Save for Later

93.
For InnoDB tables in mysqldump an online backup that takes no locks on tables can be performed by which option?

A. -multiple-transaction

B. -single-transaction

C. -double-transaction

D. -no-transaction

Answer & Solution Discuss in Board Save for Later

94.
The option which finds the startup options supported by the server through mysqld is . . . . . . . .

A. -verbose

B. -vertex

C. -startup

D. -shutdown

Answer & Solution Discuss in Board Save for Later

95.
The 'C' in the ACID property of transactions is . . . . . . . .

A. Compound

B. Concrete

C. Collision

D. Consistency

Answer & Solution Discuss in Board Save for Later

96.
Foreign keys can handle deletes and updates.

A. True

B. False

Answer & Solution Discuss in Board Save for Later

97.

Which of the following is more efficient?

LOAD DATA, INSERT

A. LOAD DATA

B. INSERT

C. Same

D. Indeterminate

Answer & Solution Discuss in Board Save for Later

98.

What will be the output of of the following SQL statement?

SELECT person_id, Fname, lname
FROM person;

A. Show only columns (person_id, Fname, lname) and rows related to these columns

B. Show only columns (person_id, Fname, lname)

C. Show all rows

D. Show all columns except (person_id, Fname, lname)

Answer & Solution Discuss in Board Save for Later

99.

Which collations does this MySQL statement list?

SHOW COLLATION LIKE 'utf8%'

A. names beginning with utf8

B. names ending with utf8

C. names containing utf8% anywhere

D. names ending in utf8%

Answer & Solution Discuss in Board Save for Later

100.
"INSERT" is same as "UPDATE"?

A. NO

B. YES

C. May be

D. None of the mentioned

Answer & Solution Discuss in Board Save for Later

1 2 3 4 5 6 7 8 9 10

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

Answer & Solution

92.
For what can the FULLTEXT indexes be created for?

Answer & Solution

93.
For InnoDB tables in mysqldump an online backup that takes no locks on tables can be performed by which option?

Answer & Solution

94.
The option which finds the startup options supported by the server through mysqld is . . . . . . . .

Answer & Solution

95.
The 'C' in the ACID property of transactions is . . . . . . . .

Answer & Solution

96.
Foreign keys can handle deletes and updates.

Answer & Solution

97.
Which of the following is more efficient?

`LOAD DATA, INSERT`

Answer & Solution

98.
What will be the output of of the following SQL statement?

`SELECT person_id, Fname, lname FROM person;`

Answer & Solution

99.
Which collations does this MySQL statement list?

`SHOW COLLATION LIKE 'utf8%'`

Answer & Solution

100.
"INSERT" is same as "UPDATE"?

Answer & Solution

Read More Section(MySQL Miscellaneous)

MySQL mcq questions and answers | MySQL MCQs

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

Answer & Solution

92. For what can the FULLTEXT indexes be created for?

Answer & Solution

93. For InnoDB tables in mysqldump an online backup that takes no locks on tables can be performed by which option?

Answer & Solution

94. The option which finds the startup options supported by the server through mysqld is . . . . . . . .

Answer & Solution

95. The 'C' in the ACID property of transactions is . . . . . . . .

Answer & Solution

96. Foreign keys can handle deletes and updates.

Answer & Solution

97. Which of the following is more efficient? LOAD DATA, INSERT

Answer & Solution

98. What will be the output of of the following SQL statement? SELECT person_id, Fname, lname FROM person;

Answer & Solution

99. Which collations does this MySQL statement list? SHOW COLLATION LIKE 'utf8%'

Answer & Solution

100. "INSERT" is same as "UPDATE"?

Answer & Solution

Read More Section(MySQL Miscellaneous)

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

92.
For what can the FULLTEXT indexes be created for?

93.
For InnoDB tables in mysqldump an online backup that takes no locks on tables can be performed by which option?

94.
The option which finds the startup options supported by the server through mysqld is . . . . . . . .

95.
The 'C' in the ACID property of transactions is . . . . . . . .

96.
Foreign keys can handle deletes and updates.

97.
Which of the following is more efficient?

`LOAD DATA, INSERT`

98.
What will be the output of of the following SQL statement?

`SELECT person_id, Fname, lname FROM person;`

99.
Which collations does this MySQL statement list?

`SHOW COLLATION LIKE 'utf8%'`

100.
"INSERT" is same as "UPDATE"?