Question

Match the term to its correct defintion

View Base tables
CREATE VIEW statement
DROP VIEW statement
A. Virtual table based on a SELECT query
B. Tables on which the view is based
C. Data definition command that removes the query specification in the data dictionary
D. Data definition command that stores the query specification in the data dictionary

Answer 1

View Base tables: Virtual table based on a SELECT query

CREATE VIEW statement: Data definition command that stores the query specification in the data dictionary

DROP VIEW statement: Data definition command that removes the query specification in the data dictionary

Step-by-step explanation:

Views are virtual tables, which can be created by select queries using the real database tables.

Creating and dropping views can be done by the CREATE VIEW and DROP VIEW statements.

CREATE VIEW syntax:

CREATE VIEW view_name AS

SELECT column1, column2, ...

FROM table_name

WHERE condition;

DROP VIEW syntax:

DROP VIEW view_name;