Multiple Choice
Contents of the BOOKS table

-Which of the following will display the new retail price of each book as 20 percent more than it originally cost?
A) none of the above
B) SELECT title,cost+.20 "New Retail Price" FROM books;
C) SELECT title,cost*.20 "New Retail Price" FROM books;
D) SELECT title,cost*1.20 "New Retail Price" FROM books;
Correct Answer:

Verified
Correct Answer:
Verified
Q79: What are the mandatory clauses of a
Q80: The _ keyword can be included in
Q81: You can include _ to override the
Q82: Concatenation refers to combining the results of
Q83: Contents of the PUBLISHER table<br> <img src="https://d2lvgg3v3hfg70.cloudfront.net/TB1929/.jpg"
Q85: If multiple column names are listed in
Q86: The <u>syntax</u> for a SQL statement gives
Q87: Parentheses can be used to override the
Q88: Which of the following keywords can be
Q89: When a user asks the database a