Oracle
1Z0-061 · Question #103
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…
The correct answer is B. UPDATE customers. See the full explanation below for the reasoning.
Question
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?
Options
- AUPDATE customers
- BUPDATE customers
- CUPDATE customers
- DUPDATE customers
How the community answered
(53 responses)- A4% (2)
- B83% (44)
- C11% (6)
- D2% (1)
Community Discussion
No community discussion yet for this question.