Resources are locked for a shorter amount of time with pessimistic locking because the transaction is pre-processed.
Correct Answer:
Verified
Q19: The DBA is responsible for managing changes
Q20: A transaction is a series of actions
Q21: The transaction boundaries are the essential information
Q22: In general,optimistic locking is the preferred technique
Q23: Resource locking must be carefully planned because
Q25: Two-phased locking has a growing phase and
Q26: A static cursor processes a snapshot of
Q27: Repeatable Read isolation is the most restrictive
Q28: In two-phase locking,all locks are obtained during
Q29: Nonrepeatable reads occur when a transaction rereads
Unlock this Answer For Free Now!
View this answer and more for free by performing one of the following actions
Scan the QR code to install the App and get 2 free unlocks
Unlock quizzes for free by uploading documents