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:
|