Database Fundamentals — Question 58
You have a table that contains information about all students in your school.
Which SQL keyword should you use to change a student's first name in the table?
Answer options
- A. UPDATE
- B. CHANGE
- C. SELECT
- D. INSERT
Correct answer: A
Explanation
The correct answer is A. UPDATE is the SQL keyword used to modify existing records in a table. The other options are incorrect because CHANGE is not a valid SQL command, SELECT is used to retrieve data, and INSERT is used to add new records rather than update existing ones.