Examice

Exam 1z0-071 All QuestionsBrowse all questions from this exam

Go to Exam

Question 196

Examine the description of the PRODUCT_INFORMATION table:

Which query retrieves the number of products with a null list price?

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

SELECT COUNT(list_price) FROM product_information WHERE list_price = NULL;

SELECT COUNT(list_price) FROM product_information WHERE list_price IS NULL;

SELECT COUNT(DISTINCT list_price) FROM product_information WHERE list_price IS NULL;

Correct Answer: C

To retrieve the number of products with a null list price, the correct SQL syntax checks for null values directly. The query should use `COUNT(list_price)` along with the condition `WHERE list_price IS NULL`, as this correctly counts only the rows where `list_price` is null. This makes option C correct.

Discussion

jfc1Option: A

A is correct

DarnunOption: A

A is correct.

yaya32Option: A

A is correct

Arth1989Option: A

A is correct. Need to convert to not NULL first.

lucemqyOption: A

A is correct