Oracle
1Z0-082 · Question #114
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 D. It executes successfully and gives the required result. See the full explanation below for the reasoning.
SQL and PL/SQL
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
How the community answered
(54 responses)- A13% (7)
- B4% (2)
- C7% (4)
- D76% (41)
Topics
#ALL keyword#GROUP BY#subqueries#set comparison
Community Discussion
No community discussion yet for this question.