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

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;

Leave A Comment?

18 + 1 =