Explain how granular locking can be used at the SERIALIZABLE isolation level.
What will be an ideal response?
If a transaction wants to read one or more tuples in a table, it gets an S lock on the entire table.
If a transaction wants to write one or more tuples in a table it gets a SIX lock on the table and
an X lock on the tuples it writes. No phantoms can occur because if one transaction has an S
lock on the table, no other transaction can get a SIX lock on that table.
You might also like to view...
List the three basic types of analog modulation.
What will be an ideal response?
Which of the following file systems uses magic numbers to identify files to the operating system?
a. NTFS b. Ext3 c. FAT32 d. FAT16 e. HPFS
When working with charts in PowerPoint, the ________ button is only active if the Microsoft Excel window is still open
A) Edit Chart B) Insert Chart C) Switch Row/Column D) Edit Data
In ____________________ transmission, data is sent when it is ready to be sent, without being synchronized.
Fill in the blank(s) with the appropriate word(s).