Oracle
1Z0-047 · Question #78
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?
Exhibit
Options
- ASELECT COUNT(list_price)
- BSELECT COUNT(list_price)
- CSELECT COUNT(NVL(list_price, 0))
- DSELECT COUNT(DISTINCT list_price)
How the community answered
(68 responses)- A10% (7)
- B7% (5)
- C79% (54)
- D3% (2)
Community Discussion
No community discussion yet for this question.