Home / Programming Questions / MySQL MCQs / Page 5

MySQL MCQs with answers Page - 5

Dear candidates you will find MCQ questions of MySQL here. Learn these questions and prepare yourself for coming examinations and interviews. You can check the right answer of any question by clicking on any option or by clicking view answer button.
Share your questions by clicking Add Question

M

Mr. Dubey • 51.17K Points
Coach

Q. Prior to MySQL 6.0, utf8 was

(A) 8 bytes
(B) 3 bytes
(C) 9 bytes
(D) 4 bytes

M

Mr. Dubey • 51.17K Points
Coach

Q. What does UTF stand for int utf8?

(A) Unicode Transformation Formula
(B) Universal Transformation Formula
(C) Unicode Transformation Format
(D) Universal Transformation Format

M

Mr. Dubey • 51.17K Points
Coach

Q. 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

M

Mr. Dubey • 51.17K Points
Coach

Q. Which collations does this statement list?

Code:
SHOW COLLATION LIKE 'utf8%'
(A) names ending in utf8%
(B) names beginning with utf8
(C) names ending with utf8
(D) names containing utf8% anywhere

M

Mr. Dubey • 51.17K Points
Coach

Q. Which statement is used to find out which character sets are available?

(A) SHOW CHARACTER SETS
(B) SHOW COLLATIONS
(C) SHOW CHARACTER SET
(D) SHOW COLLATION

M

Mr. Dubey • 51.17K Points
Coach

Q. Which clause can be used to sort string values according to a specific collation?

(A) GROUP
(B) FILTER
(C) COLLATE
(D) SORT

M

Mr. Dubey • 51.17K Points
Coach

Q. Unicode support is provided in MySQL.

(A) False
(B) True
(C) NA
(D) NA

M

Mr. Dubey • 51.17K Points
Coach

Q. What is the maximum collations a character set can have?

(A) more than 1
(B) 2
(C) 1
(D) 0

Login

Forgot username? click here

Forgot password? Click here

Don't have account? Register here.