MySQL mcq questions and answers | MySQL MCQs Page-2 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

11.
Which storage engine in MySQL provides foreign key support?

A. TRANSACTION

B. InnoDB

C. MyISAM

D. MEMORY

Answer & Solution Discuss in Board Save for Later

12.
The grant table scope columns that is case insensitive is . . . . . . . .

A. Host

B. User

C. Password

D. Db

Answer & Solution Discuss in Board Save for Later

13.

Which of these has higher priority?

writes, reads

A. writes

B. reads

C. same priority

D. machine dependent

Answer & Solution Discuss in Board Save for Later

14.
The statement used to create a trigger is . . . . . . . .

A. CREATE TRIGGER

B. CREATE TRIGGERS

C. PRODUCE TRIGGER

D. PRODUCE TRIGGERS

Answer & Solution Discuss in Board Save for Later

15.
Which statement suspends the replication related activity of the slave server?

A. RESUME SLAVE

B. START SLAVE

C. STOP SLAVE

D. GET SLAVE

Answer & Solution Discuss in Board Save for Later

16.
Find odd one out?

A. GROUP BY

B. DESC

C. ASC

D. ORDER BY

Answer & Solution Discuss in Board Save for Later

17.
Which among the following is the correct representation of "float(1,1)"?

A. Total of 1 digit

B. Total of 2 digit

C. Total of 2 digit, one digit at right of the decimal, one digit at left of the decimal

D. None of the mentioned

Answer & Solution Discuss in Board Save for Later

18.

REPAIR TABLE works with how many of the following?

MyISAM, ARCHIVE, CSV

A. 0

B. 1

C. 2

D. 3

Answer & Solution Discuss in Board Save for Later

19.
The variable which represents the default time zone of the MySQL server is . . . . . . . .

A. time_zone

B. system_time_zone

C. date_and_time

D. system_time

Answer & Solution Discuss in Board Save for Later

20.

The collations this statement lists are . . . . . . . .

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

1 2 3 4 5 6 7 8 9 10

11.
Which storage engine in MySQL provides foreign key support?

Answer & Solution

12.
The grant table scope columns that is case insensitive is . . . . . . . .

Answer & Solution

13.
Which of these has higher priority?

`writes, reads`

Answer & Solution

14.
The statement used to create a trigger is . . . . . . . .

Answer & Solution

15.
Which statement suspends the replication related activity of the slave server?

Answer & Solution

16.
Find odd one out?

Answer & Solution

17.
Which among the following is the correct representation of "float(1,1)"?

Answer & Solution

18.
REPAIR TABLE works with how many of the following?

`MyISAM, ARCHIVE, CSV`

Answer & Solution

19.
The variable which represents the default time zone of the MySQL server is . . . . . . . .

Answer & Solution

20.
The collations this statement lists are . . . . . . . .

`SHOW COLLATION LIKE 'utf8%'`

Answer & Solution

Read More Section(MySQL Miscellaneous)

MySQL mcq questions and answers | MySQL MCQs

11. Which storage engine in MySQL provides foreign key support?

Answer & Solution

12. The grant table scope columns that is case insensitive is . . . . . . . .

Answer & Solution

13. Which of these has higher priority? writes, reads

Answer & Solution

14. The statement used to create a trigger is . . . . . . . .

Answer & Solution

15. Which statement suspends the replication related activity of the slave server?

Answer & Solution

16. Find odd one out?

Answer & Solution

17. Which among the following is the correct representation of "float(1,1)"?

Answer & Solution

18. REPAIR TABLE works with how many of the following? MyISAM, ARCHIVE, CSV

Answer & Solution

19. The variable which represents the default time zone of the MySQL server is . . . . . . . .

Answer & Solution

20. The collations this statement lists are . . . . . . . . SHOW COLLATION LIKE 'utf8%'

Answer & Solution

Read More Section(MySQL Miscellaneous)

11.
Which storage engine in MySQL provides foreign key support?

12.
The grant table scope columns that is case insensitive is . . . . . . . .

13.
Which of these has higher priority?

`writes, reads`

14.
The statement used to create a trigger is . . . . . . . .

15.
Which statement suspends the replication related activity of the slave server?

16.
Find odd one out?

17.
Which among the following is the correct representation of "float(1,1)"?

18.
REPAIR TABLE works with how many of the following?

`MyISAM, ARCHIVE, CSV`

19.
The variable which represents the default time zone of the MySQL server is . . . . . . . .

20.
The collations this statement lists are . . . . . . . .

`SHOW COLLATION LIKE 'utf8%'`