View the Exhibit and examine the data in the PRODUCT_INFORMATION table. There are some products listed in the PRODUCT_INFORMATION table that have no value in the LIST_PRICE column. You issued the following SQL statement to find out the PRODUCT_NAME for these products:

SELECT product_name, list_price FROM product_information WHERE list_price = NULL; The query returns no rows. What changes would you make in the statement to get the desired result?

Question

View the Exhibit and examine the data in the PRODUCT_INFORMATION table. There are some products listed in the PRODUCT_INFORMATION table that have no value in the LIST_PRICE column. You issued the following SQL statement to find out the PRODUCT_NAME for these products:

SELECT product_name, list_price FROM product_information WHERE list_price = NULL; The query returns no rows. What changes would you make in the statement to get the desired result?

Accepted Answer

C. Change the WHERE clause to WHERE list_price IS NULL.

Answer

A. Change the WHERE clause to WHERE list_price = 0

Answer

B. Change the WHERE clause to WHERE list_price = ''.

Answer

D. In the WHERE clause, enclose NULL within single quotation marks.

Answer

E. In the WHERE clause, enclose NULL within double quotation marks.

View the Exhibit and examine the data in the PRODUCT_INFORMATION table. There are some products listed in the PRODUCT_INFORMATION table that have no value in the LIST_PRICE column. You issued the…

Question

Exhibit

Options

How the community answered

Community Discussion