When defining a view using SQL:
A) The SQL does not have to contain a select statement that defines the virtual or derived table
B) The select statement in the SQL must contain a reference to only one table
C) The column names of the virtual or derived table can be renamed in the SQL.
D) The column names of the virtual or derived table will always match the column names in the select statement

Question

Quizplus · Accepted Answer

The column names of the virtual or derived table can be renamed in the SQL when defining a view. This is done by giving alias names to the columns in the select statement. The other options are incorrect as the SQL must include a select statement to define the virtual table (option A), the select statement can contain references to multiple tables (option B), and the column names in the virtual table can be renamed using aliases (option D).

When Defining a View Using SQL