MySQL mcq questions and answers | MySQL MCQs Page-8 section-1

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.
The default storage engine used is . . . . . . . .

A. EXAMPLE

B. ARCHIVE

C. MyISAM

D. NDB

Answer & Solution Discuss in Board Save for Later

72.
The number of values that can be returned from a given stored function is . . . . . . . .

A. 0

B. 1

C. 2

D. 3

Answer & Solution Discuss in Board Save for Later

73.
A synonym for CHARACTER SET is . . . . . . . .

A. CSET

B. CHSET

C. CHARSET

D. CHCSET

Answer & Solution Discuss in Board Save for Later

74.
The IN, OUT and INOUT keywords do not apply to stored functions.

A. True

B. False

Answer & Solution Discuss in Board Save for Later

75.
To perform consistency checks on a MyISAM table the statement is . . . . . . . .

A. CHECK TABLE

B. REPAIR TABLE

C. ANALYZE TABLE

D. OPTIMIZE TABLE

Answer & Solution Discuss in Board Save for Later

76.
The character that the MySQL client program recognizes as a statement delimiter is . . . . . . . .

A. :

B. .

C. ;

D. ,

Answer & Solution Discuss in Board Save for Later

77.
Which system variable controls the size of the table cache?

A. table_cache

B. cache_table

C. open_cache

D. cache_open

Answer & Solution Discuss in Board Save for Later

78.
The embedded server library containing the MySQL server linkable into applications is . . . . . . . .

A. libmysqla

B. libmysqlb

C. libmysqlc

D. libmysqld

Answer & Solution Discuss in Board Save for Later

79.

How many of the following return rows?

SELECT, SHOW, DESCRIBE

A. 0

B. 1

C. 2

D. 3

Answer & Solution Discuss in Board Save for Later

80.
Which of these modes is a composite server mode?

A. COMPOSITE

B. COMPOSITE_MODE

C. COMPOSITE_SERVER

D. ANSI

Answer & Solution Discuss in Board Save for Later

1 2 3 4 5 6 7 8 9 10

71.
The default storage engine used is . . . . . . . .

Answer & Solution

72.
The number of values that can be returned from a given stored function is . . . . . . . .

Answer & Solution

73.
A synonym for CHARACTER SET is . . . . . . . .

Answer & Solution

74.
The IN, OUT and INOUT keywords do not apply to stored functions.

Answer & Solution

75.
To perform consistency checks on a MyISAM table the statement is . . . . . . . .

Answer & Solution

76.
The character that the MySQL client program recognizes as a statement delimiter is . . . . . . . .

Answer & Solution

77.
Which system variable controls the size of the table cache?

Answer & Solution

78.
The embedded server library containing the MySQL server linkable into applications is . . . . . . . .

Answer & Solution

79.
How many of the following return rows?

`SELECT, SHOW, DESCRIBE`

Answer & Solution

80.
Which of these modes is a composite server mode?

Answer & Solution

Read More Section(MySQL Miscellaneous)

MySQL mcq questions and answers | MySQL MCQs

71. The default storage engine used is . . . . . . . .

Answer & Solution

72. The number of values that can be returned from a given stored function is . . . . . . . .

Answer & Solution

73. A synonym for CHARACTER SET is . . . . . . . .

Answer & Solution

74. The IN, OUT and INOUT keywords do not apply to stored functions.

Answer & Solution

75. To perform consistency checks on a MyISAM table the statement is . . . . . . . .

Answer & Solution

76. The character that the MySQL client program recognizes as a statement delimiter is . . . . . . . .

Answer & Solution

77. Which system variable controls the size of the table cache?

Answer & Solution

78. The embedded server library containing the MySQL server linkable into applications is . . . . . . . .

Answer & Solution

79. How many of the following return rows? SELECT, SHOW, DESCRIBE

Answer & Solution

80. Which of these modes is a composite server mode?

Answer & Solution

Read More Section(MySQL Miscellaneous)

71.
The default storage engine used is . . . . . . . .

72.
The number of values that can be returned from a given stored function is . . . . . . . .

73.
A synonym for CHARACTER SET is . . . . . . . .

74.
The IN, OUT and INOUT keywords do not apply to stored functions.

75.
To perform consistency checks on a MyISAM table the statement is . . . . . . . .

76.
The character that the MySQL client program recognizes as a statement delimiter is . . . . . . . .

77.
Which system variable controls the size of the table cache?

78.
The embedded server library containing the MySQL server linkable into applications is . . . . . . . .

79.
How many of the following return rows?

`SELECT, SHOW, DESCRIBE`

80.
Which of these modes is a composite server mode?