Which Type of View Is Created from the Following SQL

question 15

Multiple Choice

Which type of view is created from the following SQL command?
CREATE OR REPLACE VIEW prices
AS SELECT isbn,title,cost,retail,retail-cost profit,name
FROM books NATURAL JOIN publisher;

• A) ​complex
• B) ​simple
• C) ​inline
• D) ​none of the above

---

Definitions:

Average Fixed Cost

The fixed expenses of a company divided by the number of units produced, showing cost per unit.

Average Variable Cost

Average variable cost is the total variable costs of production divided by the quantity of output produced; it changes with production volume.

Marginal Cost

The expenditure required to produce one more unit of a product or service.

Incremental Cost

The additional cost associated with producing one more unit of a product or service.