The ____ clause can effectively lock everything within a transaction until the transaction is completed by a commit or rollback.
A) COMMIT
B) FOR UPDATE
C) BLOCK
D) LOCK

Question

Quizplus · Accepted Answer

The FOR UPDATE clause locks the selected rows in a transaction until the transaction is committed or rolled back. This helps in preventing two concurrent transactions from modifying the same data and causing data inconsistencies. The other options, COMMIT, BLOCK, and LOCK, do not provide this functionality.

The ____ Clause Can Effectively Lock Everything Within a Transaction