1Z0-873 · Question #46
1Z0-873 Question #46: Real Exam Question with Answer & Explanation
The correct answer is A. A read lock allows other clients to read the same data, however will prevent any modification of D. A write lock prevents any other client from reading or writing the locked data until the lock is. The following list describes the available lock types and their effects: Locks a table for reading. A READ lock locks a table for read queries such as SELECT that retrieve data from the table. It does not allow write operations such as INSERT, DELETE, or UPDATE that modify the ta
Question
Options
- AA read lock allows other clients to read the same data, however will prevent any modification of
- BA read lock prevents any other client from reading the same data, until the lock is released.
- CA write lock only prevents any other client from modifying the locked data until the lock is
- DA write lock prevents any other client from reading or writing the locked data until the lock is
Explanation
The following list describes the available lock types and their effects: Locks a table for reading. A READ lock locks a table for read queries such as SELECT that retrieve data from the table. It does not allow write operations such as INSERT, DELETE, or UPDATE that modify the table, even by the client that holds the lock. 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. A client that wants to write to a table that is read-locked must wait until all clients currently reading from it have finished and released their locks. Locks a table for writing. A WRITE lock is an exclusive lock. It can be acquired only when a table is not being used. 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.
Community Discussion
No community discussion yet for this question.