Oracle Database SQL 12c 1z0-071 Exam Practice Test 1

Question : 25 of 50

Marks: +1, -0

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?

SELECT COUNT (DISTINCT list_price) FROM product_information WHERE list_price is NULL
SELECT COUNT (NVL(list_price, 0)) FROM product_information WHERE list_price is NULL
SELECT COUNT (list_price) FROM product_information WHERE list_price i= NULL
SELECT COUNT (list_price) FROM product_information WHERE list_price is NULL

Go to Question:

Prev Question

Next Question