Database Management System

Unit 4: Transaction Processing Concept

  • Q1). What is transaction concept?
  • Q2). Explain the ACID property of transaction.
  • Q3). What is Serializability?
  • Q4). Explain the view Serializability.
  • Q5). Discuss conflict Serializability.
  • Q6). What is Recoverability?
  • Q7). What are Schedules? What are differences between conflict serializablity and view serializablity ? Explain with suitable example what are cascadeless and recoverable schedules?
  • Q8). Explain cascadeless schedules and cascading rollback.
  • Q9). 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?
  • Q10). What is log? How it is maintained? Discuss salient feature of deferred database modification and immediate database modification strategies in brief.
  • Q11). Describe the shadow paging recovery tecnique. Under what circumstances does it not require a log?
  • Q12). What is deadlock? When does it occur? How is it detected in database system? How can it be avoided? Discuss in detail.
  • Q13). Discuss the procedure of deadlock detection and recovery in transaction.
  • Q14). Explain the transaction wait-for graph.
  • Q15). Define phantom deadlock and discuss a protocol for detection of a deadlock and explain how detection of phantom deadlocks may be avoided.
  • Q16). What is fragmentation of a relation? Describe the main types of fragmentation.
  • Q17). Briefly explain the distributed database and outline the objectives of distributed database.
  • Q18). What is meant by data allocation in distributed database desing? Describe the crieteria to allocate the database inits over the various sites.
  • Q19). What is mixed fragmentation in distributed database design? Explain.
  • Q20). Explain homogeneous and heterogeneous database reference to distributed database.
  • Q21). Discuss the procedure of deadlock detection and recovery in transactions.
  • Q22). What do you mean by Transparency?
  • Q23). Explain in detail the various approaches used for storing a relation in distributed database.