nerdexam
Oracle

1Z0-061 · Question #21

Examine the structure of the products table: You want to display the names of the products that have the highest total value for UNIT_PRICE * QTY_IN_HAND. Which SQL statement gives the required…

The correct answer is A. Option A. See the full explanation below for the reasoning.

Question

Examine the structure of the products table:

You want to display the names of the products that have the highest total value for UNIT_PRICE

  • QTY_IN_HAND.

Which SQL statement gives the required output?

Exhibits

1Z0-061 question #21 exhibit 1
1Z0-061 question #21 exhibit 2

Options

  • AOption A
  • BOption B
  • COption C
  • DOption D

How the community answered

(45 responses)
  • A
    78% (35)
  • B
    2% (1)
  • C
    13% (6)
  • D
    7% (3)

Community Discussion

No community discussion yet for this question.

Full 1Z0-061 Practice