Home / Programming Questions / MySQL MCQs / Page 4

MySQL MCQs with answers Page - 4

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

Q. ‘fetchrow_hashref()’ returns reference to hash of row values keyed by what?

(A) table name
(B) row name
(C) database name
(D) column name

Q. MySQL does provides a date type that has an optional time part.

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

Q. The variable that checks for availability of SSL support is ____________.

(A) ssl_avail
(B) avail_ssl
(C) has_ssl
(D) have_ssl

Q. Which grant table scope columns is case insensitive?

(A) User
(B) Host
(C) Db
(D) Password

Q. What is the TLS protocol?

(A) transport level security
(B) transparent level security
(C) transparent layer security
(D) transport layer security

Q. The number of files that each end of a client/server connection including SSL support use to set up secure communications is __________.

(A) 3
(B) 2
(C) 1
(D) 0

Q. What is generally used as a synonym for CHARACTER SET?

(A) CHARSET
(B) CHCSET
(C) CSET
(D) CHSET

Q. Post MySQL 6.0, utf8 was

(A) 5 bytes
(B) 3 bytes
(C) 6 bytes
(D) 4 bytes

Login

Forgot username? click here

Forgot password? Click here

Don't have account? Register here.