Which SQL Statement Can Be Executed Based Upon the View

question 125

Multiple Choice

Which SQL statement can be executed based upon the view created from the following command,assuming no constraints exist on the underlying table?
CREATE VIEW prices
AS SELECT isbn,title,cost,retail,retail-cost profit
FROM books;

• A) INSERT INTO prices (title,cost,retail,profit)
• VALUES ('A NEW BOOK',49.99,69.99,20);
• B) ​INSERT INTO prices (title,cost,retail,profit)
• VALUES ('A SECOND BOOK',49.99,39.99,-10);
• C) ​INSERT INTO prices (title,cost,retail)
• VALUES ('A NEW BOOK',49.99,69.99);
• D) ​none of the above

---

Definitions:

Maker's Obligation

The responsibility of the creator of a negotiable instrument to pay the specified amount to the holder of the instrument upon its presentation.

Draft

Any instrument (such as a check) drawn on a drawee (such as a bank) that orders the drawee to pay a certain sum of money, usually to a third party (the payee), on demand or at a definite future time.

Drawee

The party that is ordered to pay a draft or check. With a check, a financial institution is always the drawee.

Payee

The individual or entity to whom a payment is to be made or has been made, typically in the context of financial transactions.