When Defining a View Using SQL

question 29

Multiple Choice

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

---

Definitions:

Period Cost

Costs that are not directly tied to the production process and are expensed in the period in which they are incurred, such as selling and administrative expenses.

Advertising Cost

The expense incurred by an entity to promote its products, services, or brand through various media channels.

Production Equipment

Machinery and tools used in the manufacturing process to produce finished goods.

Factory Supervisor

A role responsible for overseeing the operation of a manufacturing facility, including managing employees and ensuring production targets are met.