nerdexam
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

1Z0-047 question #66 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)
  • A
    78% (39)
  • B
    8% (4)
  • D
    14% (7)

Community Discussion

No community discussion yet for this question.

Full 1Z0-047 Practice