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.
What executes on a time activated basis according to a schedule?

A. Stored program

B. Events

C. Triggers

D. Stored procedures

Answer & Solution Discuss in Board Save for Later

72.
Which system variable tells how far into the rest of each incomplete plan the optimizer should look to evaluate whether it should be expanded further?

A. optimizer_prune_level

B. optimizer_search_depth

C. optimizer_search

D. optimizer_prune

Answer & Solution Discuss in Board Save for Later

73.
A password applies locally to an account.

A. True

B. False

Answer & Solution Discuss in Board Save for Later

74.
The join in which all the rows from the right table appear in the output irrespective of the content of the other table is . . . . . . . .

A. CARTESIAN JOIN

B. CROSS JOIN

C. INNER JOIN

D. RIGHT JOIN

Answer & Solution Discuss in Board Save for Later

75.
The tool for copying databases is . . . . . . . .

A. mysql

B. mysqlcheck

C. mysqlhotcopy

D. mysqlisamchk

Answer & Solution Discuss in Board Save for Later

76.
What is the embedded server library when building from source enabled by?

A. -with-embedded-server

B. -with-server-embedded

C. -with-embedded-library

D. -with-library-embedded

Answer & Solution Discuss in Board Save for Later

77.
Which clause is used to "filter out unwanted Groups"?

A. HAVING

B. FROM

C. WHERE

D. SELECT

Answer & Solution Discuss in Board Save for Later

78.
The "Mysql command line tool" format the results in which of the following format?

A. Rectangle

B. Square

C. Sphere

D. None of the mentioned

Answer & Solution Discuss in Board Save for Later

79.
Encrypted connections can be established using . . . . . . . .

A. exec_stmt_ssl

B. exec_ssl_stmt

C. exec_stmnt_ssl

D. exec_ssl_stmnt

Answer & Solution Discuss in Board Save for Later

80.
Which module links DBI to the web?

A. CGI.pn

B. CGI.pem

C. CGI.pm

D. CGI.po

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. What executes on a time activated basis according to a schedule?

Answer & Solution

72. Which system variable tells how far into the rest of each incomplete plan the optimizer should look to evaluate whether it should be expanded further?

Answer & Solution

73. A password applies locally to an account.

Answer & Solution

74. The join in which all the rows from the right table appear in the output irrespective of the content of the other table is . . . . . . . .

Answer & Solution

75. The tool for copying databases is . . . . . . . .

Answer & Solution

76. What is the embedded server library when building from source enabled by?

Answer & Solution

77. Which clause is used to "filter out unwanted Groups"?

Answer & Solution

78. The "Mysql command line tool" format the results in which of the following format?

Answer & Solution

79. Encrypted connections can be established using . . . . . . . .

Answer & Solution

80. Which module links DBI to the web?

Answer & Solution

Read More Section(MySQL Miscellaneous)

71.
What executes on a time activated basis according to a schedule?

72.
Which system variable tells how far into the rest of each incomplete plan the optimizer should look to evaluate whether it should be expanded further?

73.
A password applies locally to an account.

74.
The join in which all the rows from the right table appear in the output irrespective of the content of the other table is . . . . . . . .

75.
The tool for copying databases is . . . . . . . .

76.
What is the embedded server library when building from source enabled by?

77.
Which clause is used to "filter out unwanted Groups"?

78.
The "Mysql command line tool" format the results in which of the following format?

79.
Encrypted connections can be established using . . . . . . . .

80.
Which module links DBI to the web?