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. |
Which of the following does not support a materialized view? |
| A. | MySQL |
| B. | Oracle |
| C. | PostgreSQL |
| D. | SybaseSQL |
| Answer» B. Oracle | |
| 2. |
What can be used to check for views that have been invalidated by DROP or ALTER operations? |
| A. | CREATE TABLE |
| B. | VERIFY TABLE |
| C. | DETAILS TABLE |
| D. | CHECK TABLE |
| Answer» E. | |
| 3. |
What cannot be done on a view? |
| A. | display |
| B. | filter |
| C. | index |
| D. | drop |
| Answer» D. drop | |
| 4. |
A view can be deleted using the command __________ |
| A. | REMOVE |
| B. | DELETE |
| C. | CLEAR |
| D. | DROP |
| Answer» E. | |
| 5. |
Views are not updatable. |
| A. | True |
| B. | False |
| Answer» C. | |
| 6. |
What is xyz in the following MySQL statement? |
| A. | table |
| B. | column |
| C. | view |
| D. | databaseView Answer |
| Answer» D. databaseView Answer | |
| 7. |
A_VIEW_CAN_BE_DELETED_USING_THE_COMMAND___________?$ |
| A. | REMOVE |
| B. | DELETE |
| C. | CLEAR |
| D. | DROP |
| Answer» E. | |
| 8. |
What_cannot_be_done_on_a_view?$ |
| A. | display |
| B. | filter |
| C. | index |
| D. | drop |
| Answer» B. filter | |
| 9. |
A view can refer to multiple tables via __________ |
| A. | UNION |
| B. | JOIN |
| C. | GROUP |
| D. | SELECT |
| Answer» E. | |
| 10. |
table |
| A. | column |
| B. | view |
| C. | database |
| Answer» C. database | |
| 11. |
A View can be used to select a subset of the table columns. |
| A. | True |
| B. | False |
| Answer» B. False | |
| 12. |
Which of these is also known as a virtual table? |
| A. | SCHEMA |
| B. | DATABASE |
| C. | JOIN |
| D. | VIEW |
| Answer» E. | |