Oracle
1Z0-047 · Question #66
View the Exhibit and examine the description of the PRODUCT_INFORMATION table. SELECT product_name, list_price, min_price, list_price - min_price Difference FROM product_information Which options…
The correct answer is A. ORDER BY 4 C. ORDER BY DIFFERENCE E. ORDER BY LIST_PRICE - MIN_PRICE. See the full explanation below for the reasoning.
Question
View the Exhibit and examine the description of the PRODUCT_INFORMATION table. SELECT product_name, list_price, min_price, list_price - min_price Difference FROM product_information Which options when used with the above SQL statement can produce the sorted output in ascending order of the price difference between LIST_PRICE and MIN_PRICE? (Choose all that apply.)
Exhibit
Options
- AORDER BY 4
- BORDER BY MIN_PRICE
- CORDER BY DIFFERENCE
- DORDER BY LIST_PRICE
- EORDER BY LIST_PRICE - MIN_PRICE
How the community answered
(50 responses)- A78% (39)
- B8% (4)
- D14% (7)
Community Discussion
No community discussion yet for this question.
