Oracle
1Z0-071 · Question #293
1Z0-071 Question #293: Real Exam Question with Answer & Explanation
The correct answer is D. SELECT COUNT(NVL(list_price, 0)) FROM product_information WHERE list_price IS NULL;. See the full explanation below for the reasoning.
Question
Examine the description of the PRODUCT_INFORMATION table: Which query retrieves the number of products with a null list price?
Options
- ASELECT COUNT (DISTINCT list_price) FROM product_information WHERE list_price IS NULL;
- BSELECT COUNT (list_price) FROM product_information WHERE list_price IS NULL;
- CSELECT COUNT (list_price) FROM product_information WHERE list_price = NULL;
- DSELECT COUNT(NVL(list_price, 0)) FROM product_information WHERE list_price IS NULL;
Community Discussion
No community discussion yet for this question.