Which isolation level offers the greatest protection of data but provides the least amount of concurrency?
Which isolation level offers the greatest protection of data but provides the least amount of
concurrency?
What factor influences lock escalation?
What factor influences lock escalation?
Which type of lock allows the lock owner and all concurrent applications to read, but not update, the locked d
Which type of lock allows the lock owner and all concurrent applications to read, but not update,
the locked data?
what isolation level must application APP_B use?
Application APP_A is performing updates to table TAB1 using the cursor stability (CS) isolation
level. If application APP_B wants to retrieve all rows from table TAB1 without waiting for
application APP_A to finish making updates, what isolation level must application APP_B use?
Which statement will prevent concurrent application processes from performing anything other than read-only op
Which statement will prevent concurrent application processes from performing anything other
than read-only operations against a table named TAB1?
When is an INTENT EXCLUSIVE (IX) lock required?
When is an INTENT EXCLUSIVE (IX) lock required?
What is the act of exchanging one lock an application holds on a resource for a more restrictive lock on the s
What is the act of exchanging one lock an application holds on a resource for a more restrictive
lock on the same resource known as?
What isolation level prevents dirty reads, nonrepeatable reads, and phantoms?
What isolation level prevents dirty reads, nonrepeatable reads, and phantoms?
Which operation normally does NOT require an exclusive lock?
Which operation normally does NOT require an exclusive lock?
what happens?
When a COMMIT statement is executed, what happens?