JNTU
JNTU MCA 2019 DISTRIBUTED DATABASES Previous Question Paper (April/May - 2019 - R15)
Note: This question paper contains two parts A and B. Part A is compulsory which carries 25 marks. Answer all questions in Part A. Part B consists of 5 Units. Answer any one full question from each unit. Each question carries 10 marks and may have a, b, c as sub questions.
PART - A
Answer all questions. Each question carries 5 marks.
Discuss the relative advantages of centralized and distributed databases.
Answer
Centralized databases offer simplicity in management, easier security enforcement, and data consistency as all data resides in one location. However, they suffer from a single point of failure and potential performance bottlenecks. Distributed databases provide high availability, improved performance through local data access, and scalability. The trade-offs involve increased complexity in maintaining data consistency, distributed transaction management, and higher overhead for network communication.
Discuss about translation of global queries into fragmented queries.
Answer
Global query translation involves mapping a query expressed on a global schema to a query on fragmented relations. The process follows these steps:
- Normalization: The query is converted into a standard form (e.g., Conjunctive Normal Form).
- Analysis: The system checks for semantic correctness and identifies the fragments involved.
- Localization: The global query is replaced by a query referencing fragments using the fragmentation schema (e.g., horizontal or vertical fragmentation definitions).
- Simplification: Redundant operations are removed, and the query is optimized by applying selection and projection push-down techniques to reduce data transfer.
Explain Deadlocks in distributed database.
Answer
Sign in to view the complete answer paper.
Explain about 3-phase commitment protocol.
Answer
Sign in to view the complete answer paper.
Explain about multi database concurrency control.
Answer
Sign in to view the complete answer paper.
PART - B
Answer any one full question from each unit.
Explain how to differ the following : fragmentation transparency, replication transparency and location transparency.
Answer
Sign in to view the complete answer paper.
What is meant by data fragmentation in distributed database?
Answer
Sign in to view the complete answer paper.
Explain about integrity constraints in distributed database.
Answer
Sign in to view the complete answer paper.
Explain reference architecture for distributed databases.
Answer
Sign in to view the complete answer paper.
Discuss how query optimization is done using AHY algorithm.
Answer
Sign in to view the complete answer paper.
Explain the Framework for Query Optimization.
Answer
Sign in to view the complete answer paper.
Explain about Parametric Queries in distributed database.
Answer
Sign in to view the complete answer paper.
Explain about the Evaluation of Aggregate Function.
Answer
Sign in to view the complete answer paper.
Explain Deadlock prevention in distributed databases.
Answer
Sign in to view the complete answer paper.
Explain the deadlock detection in distributed database.
Answer
Sign in to view the complete answer paper.
Explain about the serilizability in distributed database.
Answer
Sign in to view the complete answer paper.
Explain about conservative time stamp method.
Answer
Sign in to view the complete answer paper.
Explain about 2-phase commitment protocol.
Answer
Sign in to view the complete answer paper.
Discus about quorum based 3-phase commitment protocol.
Answer
Sign in to view the complete answer paper.
Explain check points and cold restart in distributed database.
Answer
Sign in to view the complete answer paper.
Discuss about distributed database administration.
Answer
Sign in to view the complete answer paper.
Explain about Distributed Component Object Model.
Answer
Sign in to view the complete answer paper.
Explain the transaction management in Object DBMS.
Answer
Sign in to view the complete answer paper.
Explain the Delivery Schedule Algorithm in Push-based Technologies.
Answer
Sign in to view the complete answer paper.
Discuss between scheme Translation and scheme Integration.
Answer
Sign in to view the complete answer paper.