Contents of the BOOKS Table

question 20

Multiple Choice

Contents of the BOOKS table

-Based upon the contents of the BOOKS table, which of the following SQL statements will display the retail price for two copies of each book currently in inventory?

• A) SELECT * FROM books;
• B) SELECT title, retail+retail FROM books;
• C) SELECT title, retail^2 FROM books;
• D) none of the above

---

Definitions:

Discount

A reduction from the usual cost of something, often used as a sales strategy to encourage purchases.

Amortize

The process of spreading out a loan or intangible asset cost over a specific period of time for accounting and tax purposes.

Par Value

The nominal or face value of a bond, share of stock, or coupon as stated by the issuer; it is not indicative of the security's market value.

Semiannually

Happening biannually or once every six months.