ExamQuestions.com

Register
Login
Oracle Datbase 12c SQL Exam Questions

Oracle

Oracle Datbase 12c SQL

43 / 120

Question 43:

View the exhibit and examine the description of the PRODUCT_INFORMATION table. 
image
Which SQL statement would retrieve from the table the number of products having LIST_PRICE as NULL? 

Answer options:

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