Prev Question
Next Question

View the exhibit and examine the description of the PRODUCT_INFORMATION table.

5a2fd82450a40 - Which SQL statement would retrieve from the table the number of products having LIST_PRICE as NULL?

Which SQL statement would retrieve from the table the number of products having LIST_PRICE as NULL?

A.
SELECT COUNT (DISTINCT list_price)
FROM product_information
WHERE list_price is NULL

B.
SELECT COUNT (NVL(list_price, 0))
FROM product_information
WHERE list_price is NULL

C.
SELECT COUNT (list_price)
FROM product_information
WHERE list_price i= NULL

D.
SELECT COUNT (list_price)
FROM product_information
WHERE list_price is NULL

Prev Question
Next Question

Leave a Reply

Your email address will not be published. Required fields are marked *