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


Correct Answer:  A. A virtual table that can 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;


Correct Answer:  B. DROP TABLE CUSTOMER;

8. ON UPDATE CASCADE ensures which of the following?

A. Normalization
B. Data Integrity
C. Materialized Views
D. All of the above.


Correct Answer:  B. Data Integrity

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

A. DDL
B. DML
C. HTML
D. XML


Correct Answer:  A. DDL

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;


Correct Answer:  A. CREATE INDEX ID;

Comments

No comments yet. Why don’t you start the discussion?

Leave a Reply

Your email address will not be published. Required fields are marked *

3 × 2 =