Which statement is used to update multiple rows in a single query?
Answer options
A
WHERE clause (no additional keyword needed)
B
AND
C
WHEN
D
IN
Correct answer: WHERE clause (no additional keyword needed)
Explanation
Quick AnswerThe correct answer is WHERE clause (no additional keyword needed) because it directly addresses the core logic of Database Management.
A single UPDATE with a WHERE clause can update multiple rows simultaneously without extra keywords.