Database Design and Applications- Quiz-3 - MTech Software Systems- BITS Pilani WILP

Database Design and Applications (SSZG518)- Quiz-3

MTech Software Systems- WILP(Work Integrated Learning Programmes)  

Birla Institute of Technology and Science, Pilani

1. A schedule that will always produce identical results are serial schedule.
Select one:
True
False

Ans: False

2. Every view serializable schedule that is not conflict  serializable has blind writes.

Select one:
True
False

Ans: True

3. The point in the schedule where the transaction has obtained its final lock is known as Commit point.
Select one:
True
False

Ans: False

4. The write ahead logging protocol guarantees atomicity and durability
Select one:
True
False

Ans: True

5. The schedule is deadlock free if the Precedence graph is acyclic
Select one:
True
False

Ans: True

6. Only one exclusive lock can be placed on a resource at a time.
Select one:
True
False

Ans: True

7. Every conflict serializable schedule is also view serializable.
Select one:
True
False

Ans: True


8. There can exist view serializable schedule which is not conflict serializable.
Select one:
True
False

Ans: True


9. The DBMS creates a logpoint, in order to minimize the time taken to recover in the event of a system crash.
Select one:
True
False

Ans: Fasle


10.Locks are released when the transaction is committed successfully.
Select one:
True
False

Ans: True