Oracle
1Z0-061 · Question #171
View the Exhibit and examine the structure of the PROMOTIONS, SALES, and CUSTOMER tables. You need to generate a report showing the promo name along with the customer name for all products that were…
The correct answer is B. It executes successfully but does not give the required result. See the full explanation below for the reasoning.
Question
View the Exhibit and examine the structure of the PROMOTIONS, SALES, and CUSTOMER tables. You need to generate a report showing the promo name along with the customer name for all products that were sold during their promo campaign and before 30th October 2007. You issue the following query:
Which statement is true regarding the above query?
Exhibits
Options
- AIt executes successfully and gives the required result.
- BIt executes successfully but does not give the required result.
- CIt produces an error because the join order of the tables is incorrect.
- DIt produces an error because equijoin and nonequijoin conditions cannot be used in the same
How the community answered
(49 responses)- A10% (5)
- B82% (40)
- C2% (1)
- D6% (3)
Community Discussion
No community discussion yet for this question.