What is the act of releasing a large number of row-level locks that an application holds on a single table to
What is the act of releasing a large number of row-level locks that an application holds on a
single table to acquire a table-level lock known as?
When is an INTENT EXCLUSIVE (IX) lock required?
When is an INTENT EXCLUSIVE (IX) lock required?
which of the following?
The EXCLUSIVE MODE option of the LOCK TABLE statement is used to prevent which of
the following?
What factor influences lock conversion/promotion?
What factor influences lock conversion/promotion?
Which isolation level will allow application APP_B to retrieve all rows from table TAB1 immediately, rather th
Application APP_A is performing updates to table TAB1 using the read stability (RS)
isolation level. Which isolation level will allow application APP_B to retrieve all rows from
table TAB1 immediately, rather than have to wait until application APP_A has finished
making updates?
what is the default isolation level used?
If no isolation level is specified, what is the default isolation level used?
What isolation level prevents dirty reads, nonrepeatable reads, and phantoms?
What isolation level prevents dirty reads, nonrepeatable reads, and phantoms?