Database Fundamentals — Question 83

This question requires that you evaluate the underlined text to determine if it is correct.
You have a table that contains information about all students in your school.
You use the INSERT SQL keyword to change a student's given name in the table.
Instructions: Review the underlined text. If it makes the statement correct, select `No change is needed.` If the statement is incorrect, select the answer choice that makes the statement correct.

Answer: B -

Answer options

• A. CHANGE
• B. UPDATE
• C. No change needed
• D. SELECT

Correct answer: B

Explanation

The correct answer is B, UPDATE, because the UPDATE SQL command is specifically designed to modify existing records in a database. INSERT, on the other hand, is used to add new records rather than change existing ones, making the original statement incorrect.