Multiple Granularity - DBMS Questions and Answers

1.

If a node is locked in __________ explicit locking is being done at a lower level of the tree, but with only shared-mode locks.

   A.) Intention lock modes
   B.) Intention-shared-exclusive mode
   C.) Intention-exclusive (IX) mode
   D.) Intention-shared (IS) mode

Answer: Option 'A'

There is an intention mode associated with shared mode, and there is one with an exclusive mode.

2.

The _____________ ensures that any conflicting read and write operations are executed in timestamp order.

   A.) Timestamp-ordering protocol
   B.) Timestamp protocol
   C.) W-timestamp
   D.) R-timestamp

Answer: Option 'A'

The most common method for doing ordering transaction is to use a timestamp-ordering scheme.

3.

This validation scheme is called the _________ scheme since transactions execute optimistically, assuming they will be able to finish execution and validate at the end.

   A.) Validation protocol
   B.) Validation-based protocol
   C.) Timestamp protocol
   D.) Optimistic concurrency-control

Answer: Option 'A'

Validation protocol
A concurrency-control scheme imposes the overhead of code execution and possible delay of transactions. It may be better to use an alternative scheme that imposes less overhead.

4.

If a node is locked in an intention mode, explicit locking is done at a lower level of the tree. This is called

   A.) Intention lock modes
   B.) Explicit lock
   C.) Implicit lock
   D.) Exclusive lock

Answer: Option 'A'

Intention lock modes
There is an intention mode associated with shared mode, and there is one with an exclusive mode.

5.

If a node is locked in ______________ the subtree rooted by that node is locked explicitly in shared mode, and that explicit locking is being done at a lower level with exclusive-mode locks.

   A.) Intention lock modes
   B.) shared and intention-exclusive (SIX) mode
   C.) Intention-exclusive (IX) mode
   D.) Intention-shared (IS) mode

Answer: Option 'B'

shared and intention-exclusive (SIX) mode

Multiple Granularity - DBMS Questions and Answers Download Pdf