Which Type of View Is Created from the Following SQL

question 30

Multiple Choice

Which type of view is created from the following SQL statement?
CREATE VIEW balancedue
AS SELECT customer#,order#,SUM(quantity*retail) amtdue
FROM customers NATURAL JOIN orders NATURAL JOIN
Orderitems NATURAL JOIN books
GROUP BY customer#,order#;

• A) ​simple
• B) ​complex
• C) ​inline
• D) ​partial

---

Definitions:

Merchandise Inventory

Goods a company intends to sell to customers that are considered a current asset on the balance sheet.

Cash Budget

A financial plan that estimates a company's cash inflows and outflows over a specified period, helping in managing liquidity.

Cash Disbursements

The process of paying out money from a company or individual's cash account, usually including expenses, debt payments, and other financial transactions.

Financing Required

The total amount of money needed to start or expand an enterprise, often reflecting external funding needs to cover projected deficits or investments.