Multiple Choice
Contents of the BOOKS table
-Which of the following SQL statements will display the profit generated by each book currently stored in the BOOKS table?
A) SELECT title,retail,cost profit FROM books;
B) SELECT title,retail-cost FROM books;
C) all of the above
D) SELECT * FROM books;
Correct Answer:

Verified
Correct Answer:
Verified
Q1: The <u>DISTINCT</u> keyword can be used to
Q2: Contents of the PUBLISHER table<br> <img src="https://d2lvgg3v3hfg70.cloudfront.net/TB1929/.jpg"
Q3: Contents of the PUBLISHER table<br> <img src="https://d2lvgg3v3hfg70.cloudfront.net/TB1929/.jpg"
Q5: When solving arithmetic expressions,Oracle 12c always resolves
Q6: A string literal must be enclosed in
Q7: Which of the following types of columns
Q8: The <u>SELECT </u>clause identifies the table containing
Q9: To indicate which database table contains the
Q10: Which of the following symbols represents all
Q11: A(n)_ is an alternative column heading displayed