nerdexam
Oracle

1Z0-071 · Question #48

View the exhibits and examine the structures of the COSTS and PROMOTIONS tables. Evaluate the following SQL statement: What would be the outcome of the above SQL statement?

The correct answer is D. It displays prod IDs in the promos with cost less than the highest cost in the same time interval. See the full explanation below for the reasoning.

Question

View the exhibits and examine the structures of the COSTS and PROMOTIONS tables. Evaluate the following SQL statement:

What would be the outcome of the above SQL statement?

Exhibits

1Z0-071 question #48 exhibit 1
1Z0-071 question #48 exhibit 2
1Z0-071 question #48 exhibit 3

Options

  • AIt displays prod IDs in the promo with the lowest cost.
  • BIt displays prod IDs in the promos with the lowest cost in the same time interval.
  • CIt displays prod IDs in the promos with the highest cost in the same time interval.
  • DIt displays prod IDs in the promos with cost less than the highest cost in the same time interval.

How the community answered

(22 responses)
  • A
    14% (3)
  • B
    5% (1)
  • C
    5% (1)
  • D
    77% (17)

Community Discussion

No community discussion yet for this question.

Full 1Z0-071 Practice