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

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

1.
Which keyword is used for sorting the data in ascending order in Mysql?

A. DESC

B. ASC

C. ALTER

D. MODIFY

Answer & Solution Discuss in Board Save for Later

2.
Which of the following statements is/are correct with respect to "VIEW"?

A. "VIEW" is a query that stored in the data dictionary

B. There is no data associated with "VIEW"

C. "VIEW" creates virtual tables in Database

D. All of the mentioned

Answer & Solution Discuss in Board Save for Later

3.
Which disk data does FILES table in INFORMATION_SCHEMA store?

A. NDB

B. NBD

C. NBK

D. NCD

Answer & Solution Discuss in Board Save for Later

4.
The TRIGGER privilege is used for the table to be able to create and drop triggers for it.

A. True

B. False

Answer & Solution Discuss in Board Save for Later

5.
What performs administrative operations?

A. mysqldump

B. mysqladmin

C. mysqlimport

D. mysqlexport

Answer & Solution Discuss in Board Save for Later

6.
The hub of a MySQL installation is . . . . . . . .

A. mysqla

B. mysqlb

C. mysqlc

D. mysqld

Answer & Solution Discuss in Board Save for Later

7.
Which variable checks for the availability of SSL support?

A. have_ssl

B. has_ssl

C. avail_ssl

D. ssl_avail

Answer & Solution Discuss in Board Save for Later

8.
SHOW DATABASES lists the databases in the server to which you are connected.

A. True

B. False

Answer & Solution Discuss in Board Save for Later

9.
Which case does InnoDB store database names in?

A. lower

B. upper

C. mixed

D. random

Answer & Solution Discuss in Board Save for Later

10.
What is the log in which data changes received from a replication master server are written?

A. error log

B. general query log

C. binary log

D. relay log

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

1. Which keyword is used for sorting the data in ascending order in Mysql?

Answer & Solution

2. Which of the following statements is/are correct with respect to "VIEW"?

Answer & Solution

3. Which disk data does FILES table in INFORMATION_SCHEMA store?

Answer & Solution

4. The TRIGGER privilege is used for the table to be able to create and drop triggers for it.

Answer & Solution

5. What performs administrative operations?

Answer & Solution

6. The hub of a MySQL installation is . . . . . . . .

Answer & Solution

7. Which variable checks for the availability of SSL support?

Answer & Solution

8. SHOW DATABASES lists the databases in the server to which you are connected.

Answer & Solution

9. Which case does InnoDB store database names in?

Answer & Solution

10. What is the log in which data changes received from a replication master server are written?

Answer & Solution

Read More Section(MySQL Miscellaneous)

1.
Which keyword is used for sorting the data in ascending order in Mysql?

2.
Which of the following statements is/are correct with respect to "VIEW"?

3.
Which disk data does FILES table in INFORMATION_SCHEMA store?

4.
The TRIGGER privilege is used for the table to be able to create and drop triggers for it.

5.
What performs administrative operations?

6.
The hub of a MySQL installation is . . . . . . . .

7.
Which variable checks for the availability of SSL support?

8.
SHOW DATABASES lists the databases in the server to which you are connected.

9.
Which case does InnoDB store database names in?

10.
What is the log in which data changes received from a replication master server are written?