DBMS
Unit 4
CONCURRENCY CONTROL AND ADVANCED DATABASES
- What is Concurrency Control? Explain its Need and Locking Methods.
- Define Deadlocks, Time-stamping Methods, and Optimistic Techniques.
- Explain Recovery Methods: Shadow-Paging and Log-Based Recovery in detail.
- What are Checkpoints? Explain.
- Write a short note on Performance Tuning, Query Optimization with respect to SQL Database.
- Draw and explain Centralized and Client-Server Architectures.
- Draw and explain 2 Tier and 3 Tier Architecture.
- What are Parallel Databases? Explain Key elements of Parallel Database Processing.
- Draw and explain Architecture of Parallel Databases.
- Explain Distributed Databases.
- Draw and explain Architecture of Distributed Databases.
- Explain Distributed Database Design.
0 matching results found