Explore topic-wise MCQs in Mysql.

This section includes 9 Mcqs, each offering curated multiple-choice questions to sharpen your Mysql knowledge and support exam preparation. Choose a topic below to get started.

1.

The following statement is valid.
SELECT name, id FROM person UNION name, salary FROM Employee;
A. False
B. True
C. NA
D. NA
E. NA
Answer» C. NA
Discussion
2.

The statement used to obtain access privileges to an account is ______________.

A. GRANT
B. NEED
C. GET
D. OBTAIN
E. None of these
Answer» B. NEED
Discussion
3.

The stored-routine privileges are contained in ______________.

A. procs_priv
B. db
C. user
D. tables_priv
E. None of these
Answer» B. db
Discussion
4.

The grant table that stores users who can connect to the server and their global privileges is ______________.

A. procs_priv
B. tables_priv
C. db
D. user
E. None of these
Answer» E. None of these
Discussion
5.

The keyword used with UNION that retains duplicate rows is ______________.

A. DISTINCT
B. STRICT
C. NARROW
D. ALL
E. None of these
Answer» E. None of these
Discussion
6.

The keyword used with UNION that does not retain duplicate rows is _____________.

A. DISTINCT
B. STRICT
C. NARROW
D. ALL
E. None of these
Answer» B. STRICT
Discussion
7.

The following statement is valid.

A. False
B. True
C. NA
D. NA
E. NA
Answer» C. NA
Discussion
8.

The operators used when a subquery returns multiple rows to be evaluated in comparison to the outer query are _____________.

A. LEFT JOIN and RIGHT JOIN
B. OUTER JOIN and INNER JOIN
C. EXISTS and NOT EXISTS
D. IN and NOT IN
E. None of these
Answer» E. None of these
Discussion
9.

The ALL subquery performs the operation _____________.

A. database
B. table
C. row
D. column
E. None of these
Answer» E. None of these
Discussion