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?
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
|
Download Printable PDF. VALID exam to help you PASS. |
 |
B