Database - Introduction to SQL

Exercise :: 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

Answer: Option A

Explanation:

No answer description available for this question. Let us discuss.

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

Explanation:

No answer description available for this question. Let us discuss.

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

Explanation:

No answer description available for this question. Let us discuss.

9. 

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

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

Answer: Option A

Explanation:

No answer description available for this question. Let us discuss.

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

Explanation:

No answer description available for this question. Let us discuss.