Database Management System Back Paper 2017-18 Solution
Short Answer

Q8. Write short answer on any TWO: [Marks: 5 x 2]

a) Serializability

b) Deadlock prevention scheme

c) Hashing

d) Concurrency problems

Ans:

(a) Serializability

Serializability is the concept in a transaction that helps to identify which non-serial schedule is correct and will maintain the database consistency. It relates to the isolation property of transaction in the database.

Serializability is the concurrency scheme where the execution of concurrent transactions is equivalent to the transactions which execute serially.

Types of Serializability

  1. Conflict Serializability
  2. View Serializability

Deadlock prevention scheme: