Oracle
1Z0-061 · Question #121
View the Exhibit and evaluate structures of the SALES, PRODUCTS, and COSTS tables. Evaluate the following SQL statements: Which statement is true regarding the above compound query?
The correct answer is C. It shows products that were sold but have no cost recorded. See the full explanation below for the reasoning.
Question
View the Exhibit and evaluate structures of the SALES, PRODUCTS, and COSTS tables. Evaluate the following SQL statements:
Which statement is true regarding the above compound query?
Options
- AIt shows products that have a cost recorded irrespective of sales
- BIt shows products that were sold and have a cost recorded
- CIt shows products that were sold but have no cost recorded
- DIt reduces an error
How the community answered
(38 responses)- A5% (2)
- B3% (1)
- C84% (32)
- D8% (3)
Community Discussion
No community discussion yet for this question.