Which SQL statement will accomplish the task?

View the Exhibit and examine the description for the CUSTOMERS table.

You want to update the CUST_CREDIT_LIMIT column to NULL for all the customers, where
CUST_INCOME_LEVEL has NULL in the CUSTOMERS table. Which SQL statement will accomplish the task?

View the Exhibit and examine the description for the CUSTOMERS table.

You want to update the CUST_CREDIT_LIMIT column to NULL for all the customers, where
CUST_INCOME_LEVEL has NULL in the CUSTOMERS table. Which SQL statement will accomplish the task?

A.
UPDATE customers
SET cust_credit_limit = NULL
WHERE CUST_INCOME_LEVEL = NULL;

B.
UPDATE customers
SET cust_credit_limit = NULL
WHERE cust_income_level IS NULL;

C.
UPDATE customersSET cust_credit_limit = TO_NUMBER(NULL)
WHERE cust_income_level = TO_NUMBER(NULL);

D.
UPDATE customers
SET cust_credit_limit = TO_NUMBER(‘ ‘, 9999)
WHERE cust_income_level IS NULL;



Leave a Reply 1

Your email address will not be published. Required fields are marked *


Hola

Hola

Fj
July 29, 2013 at 3:27 pm

besides that one “makes sense” and the other will never return any rows?

nothing is equal to null
nothing is NOT equal to null

but a NULL can be “null”. When you need to retrieve NULLS, you must use “is null”