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

M

Manisha Agrawal • 9.32K Points
Tutor III

Q. A stored procedure is invoked using the statement __________.

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

M

Manisha Agrawal • 9.32K Points
Tutor III

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

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

M

Manisha Agrawal • 9.32K Points
Tutor III

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

M

Manisha Agrawal • 9.32K Points
Tutor III

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

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

M

Manisha Agrawal • 9.32K Points
Tutor III

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

M

Manisha Agrawal • 9.32K Points
Tutor III

Q. MySQL does not provide 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. Which variable checks for availability of SSL support?

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

M

Manisha Agrawal • 9.32K Points
Tutor III

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.