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(list_price) FROM product_information WHERE list_price IS NULL;
B. SELECT COUNT(list_price) FROM product_information WHERE list_price = NULL;
C. SELECT COUNT(NVL(list_price, 0)) FROM product_information WHERE list_price IS NULL;
D. SELECT COUNT(DISTINCT list_price) FROM product_information WHERE list_price IS NULL;
|
Download Printable PDF. VALID exam to help you PASS. |
 |