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

M

Manisha Agrawal • 9.32K Points
Tutor III

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

M

Manisha Agrawal • 9.32K Points
Tutor III

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

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

M

Manisha Agrawal • 9.32K Points
Tutor III

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

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

M

Manisha Agrawal • 9.32K Points
Tutor III

Q. Which grant table scope columns is case insensitive?

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

M

Manisha Agrawal • 9.32K Points
Tutor III

Q. What is the TLS protocol?

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

M

Manisha Agrawal • 9.32K Points
Tutor III

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

M

Mr. Dubey • 51.17K Points
Coach

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

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

M

Mr. Dubey • 51.17K Points
Coach

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.