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
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;
8. ON UPDATE CASCADE ensures which of the following?
A. Normalization
B. Data Integrity
C. Materialized Views
D. All of the above.
9. SQL data definition commands make up a(n) ________ .
A. DDL
B. DML
C. HTML
D. XML
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;