General Questions

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
Answer : Option A

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;
Answer : Option B

Question 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

Question 9 :

SQL data definition commands make up a(n) ________ .


A). DDL
B). DML
C). HTML
D). XML
Answer : Option A

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;
Answer : Option A