Database Fundamentals — Question 131

What is one difference between an update statement and a delete statement?

Answer options

• A. An update statement can change only one row.
• B. A delete statement cannot use a where clause.
• C. An update statement does not remove rows from a table.
• D. A delete statement works only within a stored procedure.

Correct answer: C

Explanation

The correct answer is C because an update statement modifies existing data without removing any rows, while a delete statement specifically removes rows from a table. Option A is incorrect as an update statement can change multiple rows if specified. Option B is false because a delete statement can indeed use a where clause to target specific rows. Option D is also incorrect since delete statements can be used outside of stored procedures.