Question

The UPDATE SQL clause can _____________

(a) update only one row at a time

(b) update more than one row at a time

(c) delete more than one row at a time

(d) delete only one row at a time

I had been asked this question in an online interview.

This is a very interesting question from Basic SQL in chapter Laying the Foundation of SQL Server

Answer 1

Correct choice is (b) update more than one row at a time

Best explanation: The SQL UPDATE Query is used to modify the existing records in a table. You can use WHERE clause with UPDATE query to update selected rows otherwise all the rows would be affected.