Unit-IV

The scenario in which one failure leads to a set of transaction rollbacks is called as

• Partial schedule

• Complete schedule

• Dependent schedule

State true or false: Every cascadeless schedule is also irrecoverable

• True

• False

Which of the following are the disadvantages of transaction concurrency?

• Decreased throughput

• Consistency

• Decreased utilization

Which of the following is a transaction isolation?

• Repeatable read

• Serializable

• Read committed

The conditions for view serializability

• Initial read

• Updated read

• All the above

When is a timestamp created for a transaction?

• When execution is completed

• When execution begins

• When execution is taking place

In ___________each transaction gets its copy version of the database

• Snapshot

• Lock based

• Timestamp

What is the advantage of locking?

• control concurrency

• Is not atomic

• Is not durable

A transaction has __________ lock, it can read but cannot write on the item

• Exclusive mode

• Read only mode

• Shared mode

A transaction has ________ lock, it can both read and write on the item

• Shared mode

• Exclusive mode

• Read only mode