OCP-1Z0-051-2015-30题

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?

题意：将字段CUST_CREDIT_LIMIT 列置空，条件有字段CUST_INCOME_LEVEL Is null

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 customers
SET 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;   

sh@TESTDB> UPDATE customers

  2  SET cust_credit_limit = TO_NUMBER(' ',9999)

  3  WHERE cust_income_level IS NULL;

SET cust_credit_limit = TO_NUMBER(' ',9999)

                                  *

ERROR at line 2:

ORA-01722: invalid number

Answer: B
Explanation: