Oracle
1Z0-082 · Question #114
1Z0-082 Question #114: Real Exam Question with Answer & Explanation
The correct answer is D. It executes successfully and gives the required result. See the full explanation below for the reasoning.
Question
View the Exhibits and examine the structure of the COSTS and PROMOTIONS tables. You want to display PROD_IDS whose promotion cost is less than the highest cost PROD_ID in a promotion time interval. Examine this SQL statement: Exhibit 1. Exhibit 2. What will be the result?
Exhibits
Options
- AIt gives an error because the ALL keyword is not valid
- BIt gives an error because the GROUP BY clause is not valid
- CIt executes successfully but does not give the required result
- DIt executes successfully and gives the required result
Community Discussion
No community discussion yet for this question.