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?
Answer options
A
UPDATE customers SET cust_credit_limit = NULL WHERE cust_income_level IS NULL;
B
UPDATE customers SET cust_credit_limit = 0 WHERE cust_income_level = NULL;
C
DELETE FROM customers WHERE cust_income_level IS NULL;
D
ALTER TABLE customers SET cust_credit_limit = NULL;
Correct answer: UPDATE customers SET cust_credit_limit = NULL WHERE cust_income_level IS NULL;
Detailed Solution & Conceptual Analysis
This question has been retained as-is due to its unique context.
Key Engineering Takeaway
In Database Management, understanding the underlying mechanics of Database Management is critical for writing performant, bug-free production code and passing rigorous technical architecture reviews.