Explore topic-wise MCQs in Mysql.

This section includes 5 Mcqs, each offering curated multiple-choice questions to sharpen your Mysql knowledge and support exam preparation. Choose a topic below to get started.

1.

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

A. names ending in utf8%
B. names beginning with utf8
C. names ending with utf8
D. names containing utf8% anywhere
E. None of these
Answer» C. names ending with utf8
Discussion
2.

Which collations does this statement list?

A. names ending in utf8%
B. names beginning with utf8
C. names ending with utf8
D. names containing utf8% anywhere
E. None of these
Answer» C. names ending with utf8
Discussion
3.

Post MySQL 6.0, utf8 was ___________.

A. 5 bytes
B. 3 bytes
C. 6 bytes
D. 4 bytes
E. None of these
Answer» E. None of these
Discussion
4.

Prior to MySQL 6.0, utf8 was ___________.

A. 8 bytes
B. 3 bytes
C. 9 bytes
D. 4 bytes
E. None of these
Answer» C. 9 bytes
Discussion
5.

Which statement is used to show the server s current character set and collation settings?

A. DISP VARIABLES
B. SHOW CONSTRAINTS
C. SHOW CONSTANTS
D. SHOW VARIABLES
E. None of these
Answer» E. None of these
Discussion