MCQOPTIONS
Saved Bookmarks
MCQOPTIONS
This section includes 12 Mcqs, each offering curated multiple-choice questions to sharpen your Structured Query Language (SQL) knowledge and support exam preparation. Choose a topic below to get started.
| 1. |
The keyword used with UNION that retains duplicate rows is ______________ |
| A. | ALL |
| B. | NARROW |
| C. | STRICT |
| D. | DISTINCT |
| Answer» B. NARROW | |
| 2. |
The keyword used with UNION that does not retain duplicate rows is _____________ |
| A. | ALL |
| B. | NARROW |
| C. | STRICT |
| D. | DISTINCT |
| Answer» E. | |
| 3. |
The following MySQL statement is valid. |
| A. | True |
| B. | FalseView Answer |
| Answer» B. FalseView Answer | |
| 4. |
The grant table that stores users who can connect to the server and their global privileges are ______________ |
| A. | user |
| B. | db |
| C. | tables_priv |
| D. | procs_priv |
| Answer» B. db | |
| 5. |
THE_KEYWORD_USED_WITH_UNION_THAT_DOES_NOT_RETAIN_DUPLICATE_ROWS_IS______________?$ |
| A. | ALL |
| B. | NARROW |
| C. | STRICT |
| D. | DISTINCT |
| Answer» B. NARROW | |
| 6. |
The ALL subquery performs the operation _____________ |
| A. | row |
| B. | column |
| C. | table |
| D. | database |
| Answer» C. table | |
| 7. |
The operators used when a subquery returns multiple rows to be evaluated in comparison to the outer query are _____________ |
| A. | IN and NOT IN |
| B. | EXISTS and NOT EXISTS |
| C. | OUTER JOIN and INNER JOIN |
| D. | LEFT JOIN and RIGHT JOIN |
| Answer» B. EXISTS and NOT EXISTS | |
| 8. |
Usage of aggregates in WHERE clause is disallowed. |
| A. | True |
| B. | False |
| Answer» B. False | |
| 9. |
MySQL does not support the shared-memory connections on Windows. |
| A. | True |
| B. | False |
| Answer» C. | |
| 10. |
The statement used to obtain access privileges to an account is ______________ |
| A. | OBTAIN |
| B. | GET |
| C. | GRANT |
| D. | NEED |
| Answer» D. NEED | |
| 11. |
The stored-routine privileges are contained in ______________ |
| A. | user |
| B. | db |
| C. | tables_priv |
| D. | procs_priv |
| Answer» E. | |
| 12. |
The grant table that stores users who can connect to the server and their global privileges is ______________ |
| A. | user |
| B. | db |
| C. | tables_priv |
| D. | procs_priv |
| Answer» B. db | |