Oracle Database SQL 12c 1z0-071 Exam Practice Test 1

Question : 44 of 50

Marks: +1, -0

View the exhibits and examine the structures of the COSTS and PROMOTIONS tab

Evaluate the following SQL statement:

What would be the outcome of the above SQL statement?

It displays prod IDs in the promo with the lowest cost.
It displays prod IDs in the promos with the lowest cost in the same time interval.
It displays prod IDs in the promos with the highest cost in the same time interval.
It displays prod IDs in the promos which cost less than the highest cost in the same time interval.

Go to Question:

Prev Question

Next Question