DBMS Unit 4: Transaction Processing Concept Previous Year Questions

  1. What is transaction concept?
  2. Explain the ACID property of transaction.
  3. What is Serializability?
  4. Explain the view Serializability.
  5. Discuss conflict Serializability.
  6. What is Recoverability?
  7. What are Schedules? What are differences between conflict serializability and view serializability ? Explain with suitable example what are cascadeless and recoverable schedules?
  8. Explain cascadeless schedules and cascading rollback.
  9. What is the system log used for? What is the typical kinds of records in a system log? What are transaction commit point and why are they important?
  10. What is log? How it is maintained? Discuss salient feature of deferred database modification and immediate database modification strategies in brief.
  11. Describe the shadow paging recovery technique. Under what circumstances does it not require a log?
  12. What is deadlock? When does it occur? How is it detected in database system? How can it be avoided? Discuss in detail.
  13. Discuss the procedure of deadlock detection and recovery in transaction.
  14. Explain the transaction wait-for graph.
  15. Define phantom deadlock and discuss a protocol for detection of a deadlock and explain how detection of phantom deadlocks may be avoided.
  16. What is fragmentation of a relation? Describe the main types of fragmentation.
  17. Briefly explain the distributed database and outline the objectives of distributed database.
  18. What is meant by data allocation in distributed database design? Describe the criteria to allocate the database inits over the various sites.
  19. What is mixed fragmentation in distributed database design? Explain.
  20. Explain homogeneous and heterogeneous database reference to distributed database.
  21. Discuss the procedure of deadlock detection and recovery in transactions.
  22. What do you mean by Transparency?
  23. Explain in detail the various approaches used for storing a relation in distributed database.