Oracle
1Z0-061 · Question #308
1Z0-061 Question #308: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-061 to reveal the answer and full explanation for question #308. The question stem and answer options stay visible for context.
Question
View the Exhibits and examine the structures of the COSTS and PROMOTIONS tables. Evaluate the following SQL statement: SQL> SELECT prod_id FROM costs WHERE promo_id IN (SELECT promo_id FROM promotions WHERE promo_cost < ALL (SELECT MAX(promo_cost) FROM promotions GROUP BY (promo_end_datepromo_ begin_date))); What would be the outcome of the above SQL statement?
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.
Unlock 1Z0-061 to see the answer
You've previewed enough free 1Z0-061 questions. Unlock 1Z0-061 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.