The locking mode ____ is similar to ROW SHARE,additionally prohibiting a SHARE lock on the table.
A) SHARE ROW EXCLUSIVE
B) SHARE UPDATE
C) ROW EXCLUSIVE
D) MODE

Question

Quizplus · Accepted Answer

ROW EXCLUSIVE mode allows only a single transaction to acquire an exclusive lock on a specific row, prohibiting any other transactions from acquiring shared or exclusive locks on the same row. It also prohibits a SHARE lock on the entire table, making it similar to SHARE ROW EXCLUSIVE mode. Therefore, the correct choice is C) ROW EXCLUSIVE.

The Locking Mode ____ Is Similar to ROW SHARE,additionally Prohibiting