MCQOPTIONS
Saved Bookmarks
MCQOPTIONS
This section includes 657 Mcqs, each offering curated multiple-choice questions to sharpen your Testing Subject knowledge and support exam preparation. Choose a topic below to get started.
| 1. |
What is abc in the following statement?CREATE VIEW xyz (abc) AS SELECT a FROM t; |
| A. | view |
| B. | database |
| C. | column name |
| D. | row name |
| E. | None of these |
| Answer» D. row name | |
| 2. |
What is xyz in the following statement?CREATE VIEW xyz AS SELECT a, b FROM t; |
| A. | column |
| B. | database |
| C. | table |
| D. | view |
| E. | None of these |
| Answer» E. None of these | |
| 3. |
A view can refer to multiple tables via __________. |
| A. | SELECT |
| B. | GROUP |
| C. | UNION |
| D. | JOIN |
| E. | None of these |
| Answer» E. None of these | |
| 4. |
Which of the following does not support materialized view? |
| A. | Oracle |
| B. | SybaseSQL |
| C. | MySQL |
| D. | PostgreSQL |
| E. | None of these |
| Answer» D. PostgreSQL | |
| 5. |
A view can be deleted using the command __________. |
| A. | CLEAR |
| B. | DROP |
| C. | DELETE |
| D. | REMOVE |
| E. | None of these |
| Answer» C. DELETE | |