For each of the locking implementations of the isolation levels, state whether IS locks are required and when they can be released.
What will be an ideal response?
READ UNCOMMITTED: No read locks are required and hence no intention to read locks.
READ COMMITTED: Read locks are short term, and for each short term read lock on a tuple, a short term IS lock must be obtained on the table.
REPEATABLE READ: Read locks are long term, and for each long term read lock on a
tuple, a long term IS lock must be obtained on the table.
SERIALIZABLE: If index locking is used, a long term IS lock on the table must be
acquired. If index locking is not used, an S lock is acquired on the table and no IS lock is needed.
You might also like to view...
The person responsible for the initial development of C++ was
a. Dennis Ritchie b. James Gosling c. Brian Kernighan d. Bjarne Strousrup e. Bill Joy
A procedure-level memory location has class scope, which means it can be used onlywithin the procedure in which it is declared.
Answer the following statement true (T) or false (F)
A Linear trendline is a data line that follows a straight line with a two-period forecast
Indicate whether the statement is true or false.
Which of the following is better for presentations that users will be viewing on their own?
A. Buttons B. The On Page Click command C. The On Page Load command D. The Load Automatically command