Oracle
1Z0-061 · Question #119
1Z0-061 Question #119: Real Exam Question with Answer & Explanation
The correct answer is D. It gives details of all promos irrespective of whether they have resulted in a sale or not. See the full explanation below for the reasoning.
Question
View the Exhibits and examine the structures of the PROMOTIONS and SALES tables. Evaluate the following SQL statements: Which statement is true regarding the output of the above query?
Exhibit
Options
- AIt gives details of product IDs that have been sold irrespective of whether they had a promo or not
- BIt gives the details of promos for which there have been no sales
- CIt gives the details of promos for which there have been sales
- DIt gives details of all promos irrespective of whether they have resulted in a sale or not
Community Discussion
No community discussion yet for this question.