T3_Transacction and Recovery Management

Collection of operations that form a single logical unit of work are called                      

• Transactions
• Units
• Network
• Views

A transaction completes its execution is said to be             .

• Saved
• Loaded
• Rolled
• Committed

The property of a transaction that persists all the crashes is called             .

• Atomicity
• Durability
• Isolation
• Consistency

A schedule is serialized if it is equivalent to a              schedule.

• Non-serial
• serial
• View
• None of the mentioned

To synchronize the concurrent accessing of database items, we use :

• Transactions
• States
• Locks
• Tables

The most widely used structure for recording database modification is called as                

• List
• Queue
• Stack
• Log

The value of the data item prior to the write is called as                    

• Transaction identifier
• Data-item identifier
• Old value
• New value

Database locking concept is used to solve the problem of:

• Lost Update
• Uncommitted Dependency
• Inconsistent Data
• All of the above

If a transaction has obtained a                      lock, it can read but cannot write on the item

• Shared mode
• Exclusive mode
• Read only mode
• Write only mode

If a transaction has obtained a                  lock, it can both read and write on the item

• Shared mode
• Exclusive mode
• Read only mode
• Write only mode