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 customersSET cust_credit_limit = NULLWHERE CUST_INCOME_LEVEL = NULL;
B. UPDATE customersSET cust_credit_limit = NULLWHERE cust_income_level IS NULL;
C. UPDATE customersSET cust_credit_limit = TO_NUMBER(NULL)WHERE cust_income_level = TO_NUMBER(NULL);
D. UPDATE customersSET cust_credit_limit = TO_NUMBER(‘ ‘,9999)WHERE cust_income_level IS NULL;
|
Download Printable PDF. VALID exam to help you PASS. |
 |