Oracle
1Z0-071 · Question #43
View the Exhibit and examine the description of the PRODUCT_INFORMATION table. Which SQL statement would retrieve from the table the number of products having LIST_PRICE as NULL?
The correct answer is C. SELECT COUNT(NVL(list_price, 0)). See the full explanation below for the reasoning.
Question
View the Exhibit and examine the description of the PRODUCT_INFORMATION table. Which SQL statement would retrieve from the table the number of products having LIST_PRICE as NULL?
Options
- ASELECT COUNT(list_price)
- BSELECT COUNT(list_price)
- CSELECT COUNT(NVL(list_price, 0))
- DSELECT COUNT(DISTINCT list_price)
How the community answered
(32 responses)- A6% (2)
- B9% (3)
- C81% (26)
- D3% (1)
Community Discussion
No community discussion yet for this question.