Database - Introduction to SQL

Exercise : Introduction to SQL - General Questions
6.
A view is which of the following?
A virtual table that can be accessed via SQL commands
A virtual table that cannot be accessed via SQL commands
A base table that can be accessed via SQL commands
A base table that cannot be accessed via SQL commands
Answer: Option
Explanation:
No answer description is available. Let's discuss.

7.
The command to eliminate a table from a database is:
REMOVE TABLE CUSTOMER;
DROP TABLE CUSTOMER;
DELETE TABLE CUSTOMER;
UPDATE TABLE CUSTOMER;
Answer: Option
Explanation:
No answer description is available. Let's discuss.

8.
ON UPDATE CASCADE ensures which of the following?
Normalization
Data Integrity
Materialized Views
All of the above.
Answer: Option
Explanation:
No answer description is available. Let's discuss.

9.
SQL data definition commands make up a(n) ________ .
DDL
DML
HTML
XML
Answer: Option
Explanation:
No answer description is available. Let's discuss.

10.
Which of the following is valid SQL for an Index?
CREATE INDEX ID;
CHANGE INDEX ID;
ADD INDEX ID;
REMOVE INDEX ID;
Answer: Option
Explanation:
No answer description is available. Let's discuss.