Home / Programming Questions / MySQL MCQs / Page 1

MySQL MCQs with answers Page - 1

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. A stored procedure is invoked using the statement __________.

(A) CALL
(B) RETURN
(C) SEE
(D) INVOKE

Q. Triggers and events are not invoked automatically by the server.

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

Q. The security context when a user creates a stored program that accesses sensitive data but forgets that other people who can invoke the object have the same access is __________

(A) illegal
(B) fare
(C) bad
(D) good

Q. The datatype that stores the longest length of strings is ______________.

(A) VARCHAR
(B) TEXT
(C) CHAR
(D) TINYTEXT

Q. What is the best datatype for a column that is expected to store values up to 2 million?

(A) BIGINT
(B) SMALLINT
(C) TINYINT
(D) MEDIUMINT

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

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

Q. Which variable checks for availability of SSL support?

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

Q. The grant table scope columns that is case insensitive is _____________.

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

Login

Forgot username? click here

Forgot password? Click here

Don't have account? Register here.