Oracle
1Z0-071 · Question #128
View the Exhibit and examine the data in the PRODUCTS table. You must display product names from the PRODUCTS table that belong to the 'Software/other' category with minimum prices as either $2000…
The correct answer is A. It executes successfully but returns no result. See the full explanation below for the reasoning.
Question
View the Exhibit and examine the data in the PRODUCTS table. You must display product names from the PRODUCTS table that belong to the 'Software/other' category with minimum prices as either $2000 or $4000 and with no unit of measure. You issue this query:
Which statement is true?
Exhibits
Options
- AIt executes successfully but returns no result.
- BIt executes successfully and returns the required result.
- CIt generates an error because the condition specified for PROD_UNIT_OF_MEASURE is not
- DIt generates an error because the condition specified for the PROD_CATEGORY column is not
How the community answered
(20 responses)- A80% (16)
- B5% (1)
- C5% (1)
- D10% (2)
Community Discussion
No community discussion yet for this question.