Database - Introduction to SQL
Exercise :: Introduction to SQL - General Questions
| 6. |
A view is which of the following? |
| A. |
A virtual table that can be accessed via SQL commands | | B. |
A virtual table that cannot be accessed via SQL commands | | C. |
A base table that can be accessed via SQL commands | | D. |
A base table that cannot be accessed via SQL commands |
Answer: Option A
Explanation:
|
| 7. |
The command to eliminate a table from a database is: |
| A. |
REMOVE TABLE CUSTOMER; | | B. |
DROP TABLE CUSTOMER; | | C. |
DELETE TABLE CUSTOMER; | | D. |
UPDATE TABLE CUSTOMER; |
Answer: Option B
Explanation:
|
| 8. |
ON UPDATE CASCADE ensures which of the following? |
| A. |
Normalization | | B. |
Data Integrity | | C. |
Materialized Views | | D. |
All of the above. |
Answer: Option B
Explanation:
|
| 9. |
SQL data definition commands make up a(n) ________ . |
Answer: Option A
Explanation:
|
| 10. |
Which of the following is valid SQL for an Index? |
| A. |
CREATE INDEX ID; | | B. |
CHANGE INDEX ID; | | C. |
ADD INDEX ID; | | D. |
REMOVE INDEX ID; |
Answer: Option A
Explanation:
|
