Which query will change the cust_address to 'Panama' for those who are from ‘Los Angeles’?
Answer options
A
UPDATE customer SET cust_address = 'Panama' WHERE cust_address = 'Los Angeles';
B
UPDATE customer SET cust_address = 'Los Angeles' WHERE cust_address = 'Panama';
C
INSERT INTO customer (cust_address) VALUES ('Panama');
D
DELETE FROM customer WHERE cust_address = 'Los Angeles';
Correct answer: UPDATE customer SET cust_address = 'Panama' WHERE cust_address = 'Los Angeles';
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.