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