Oracle
1Z0-071 · Question #348
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…
The correct answer is C. 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 statements:
What will be the result? Exhibit 1. Exhibit 2.
Exhibits
Options
- AIt gives an error because the GROUP BY clause is not valid
- BIt executes successfully but does not give the required result
- CIt executes successfully and gives the required result
- DIt gives an error because the ALL keyword is not valid
How the community answered
(20 responses)- A5% (1)
- B10% (2)
- C70% (14)
- D15% (3)
Community Discussion
No community discussion yet for this question.