Difficulty: Easy
Correct Answer: UPDATE
Explanation:
Introduction / Context:
SQL provides distinct commands for creating, reading, updating, and deleting data. Choosing the correct statement avoids unintended data changes. This question focuses on modifying existing values in existing rows.
Given Data / Assumptions:
Concept / Approach:
The UPDATE statement changes column values in one or more rows that match a WHERE clause. INSERT adds new rows; APPEND is non-standard SQL terminology (sometimes used in specific tools to mean insert); BROWSE is a UI action, not an SQL command. Therefore, the precise SQL command to change existing data is UPDATE.
Step-by-Step Solution:
Identify operation type: modify existing row values.Select UPDATE … SET column = value WHERE condition.Avoid commands that add rows (INSERT/APPEND) or just view data (BROWSE).
Verification / Alternative check:
SQL documentation and examples consistently show UPDATE as the verb to change values; transactions ensure atomicity and rollback on error.
Why Other Options Are Wrong:
Common Pitfalls:
Forgetting the WHERE clause and unintentionally updating all rows; not handling NULL semantics or type conversions during updates.
Final Answer:
UPDATE
Discussion & Comments