Another user has issued the statement LOCK TABLE pets FOR WRITE You can...

The correct answer is D. None of the above. When a table is locked for reading, other clients can read from the table at the same time, but no client can write to it. Once acquired, only the client holding the write lock can read from or write to the table. Other clients can neither read from nor write to it. No other…

Transactions and Locking

Question

Options

AUpdate table pets
BSELECT from table pets
CUPDATE and SELECT from table pets
DNone of the above

How the community answered

(47 responses)

A
9% (4)
B
4% (2)
C
17% (8)
D
70% (33)

Explanation

When a table is locked for reading, other clients can read from the table at the same time, but no client can write to it. Once acquired, only the client holding the write lock can read from or write to the table. Other clients can neither read from nor write to it. No other client can lock the table for either reading or writing.

Topics

#LOCK TABLE#WRITE lock#concurrent access#table locking

Community Discussion

No community discussion yet for this question.

Full 1Z0-873 Practice