Oracle
1Z0-047 · Question #132
View the Exhibit and examine the data in the PRODUCT INFORMATION table. Which two tasks would require subqueries? (Choose two.)
The correct answer is C. displaying the number of products whose list prices are more than the average list price D. displaying all the products whose minimum list prices are more than the average list price of products. See the full explanation below for the reasoning.
Question
View the Exhibit and examine the data in the PRODUCT INFORMATION table. Which two tasks would require subqueries? (Choose two.)
Exhibit
Options
- Adisplaying the minimum list price for each product status
- Bdisplaying all supplier IDs whose average list price is more than 500
- Cdisplaying the number of products whose list prices are more than the average list price
- Ddisplaying all the products whose minimum list prices are more than the average list price of products
- Edisplaying the total number of products supplied by supplier 102071 and having product status OBSOLETE
How the community answered
(42 responses)- A7% (3)
- B5% (2)
- C71% (30)
- E17% (7)
Community Discussion
No community discussion yet for this question.