Skip to content
- What is transaction concept?
- Explain the ACID property of transaction.
- What is Serializability?
- Explain the view Serializability.
- Discuss conflict Serializability.
- What is Recoverability?
- What are Schedules? What are differences between conflict serializability and view serializability ? Explain with suitable example what are cascadeless and recoverable schedules?
- Explain cascadeless schedules and cascading rollback.
- 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?
- What is log? How it is maintained? Discuss salient feature of deferred database modification and immediate database modification strategies in brief.
- Describe the shadow paging recovery technique. Under what circumstances does it not require a log?
- What is deadlock? When does it occur? How is it detected in database system? How can it be avoided? Discuss in detail.
- Discuss the procedure of deadlock detection and recovery in transaction.
- Explain the transaction wait-for graph.
- Define phantom deadlock and discuss a protocol for detection of a deadlock and explain how detection of phantom deadlocks may be avoided.
- What is fragmentation of a relation? Describe the main types of fragmentation.
- Briefly explain the distributed database and outline the objectives of distributed database.
- What is meant by data allocation in distributed database design? Describe the criteria to allocate the database inits over the various sites.
- What is mixed fragmentation in distributed database design? Explain.
- Explain homogeneous and heterogeneous database reference to distributed database.
- Discuss the procedure of deadlock detection and recovery in transactions.
- What do you mean by Transparency?
- Explain in detail the various approaches used for storing a relation in distributed database.