MCASemester 42024-25Distributed Database SystemsKCA045
View PDFDownload

Distributed Database Systems (KCA045) - AKTU Question Paper 2024-25

MCA · Semester 4 · Free PDF Download

This is the official AKTU Distributed Database Systems Previous Year Question Paper for MCA Semester 4, academic session 2024-25. Published by Dr. A.P.J. Abdul Kalam Technical University (AKTU/UPTU), Lucknow. Free PDF download — no login required.

Course:MCA
Semester:Semester 4
Session:2024-25
University:AKTU / UPTU

Rate this paper

Questions Asked in 2024-25

Distributed Database Systems (KCA045) — complete question paper · 100 marks · 3 Hours

Section AAttempt all questions in brief. 2 x 10 = 20
  • a
    What are the main promises and challenges of distributed DBMS? CO
  • b
    Define fragmentation and explain its types with examples. CO
  • c
    What are the main objectives of distributed query processing? CO
  • d
    Describe the concept of query localization in distributed systems. CO
  • e
    What is serializability in distributed transaction management? CO
  • f
    Explain optimistic concurrency control with an example. CO
  • g
    What do you understand by fault tolerance in distributed systems? CO
  • h
    Mention key causes of failures in distributed databases. CO4 K3 i. Define object identity and inheritance in object-oriented DBMS. CO5 K5 j. What are persistent programming languages? Give two examples. CO
Section BAttempt any three of the following: 10 x 3 = 30
  • a
    Explain the architectural models of distributed DBMS with neat diagrams. CO
  • b
    Describe distributed query optimization algorithms in detail. CO
  • c
    Explain concurrency control algorithms and how deadlocks are ma naged in distributed DBMS. CO
  • d
    Discuss various fault types and reliability protocols used in distributed DBMS. CO
  • e
    Differentiate between OODBMS and ORDBMS with suitable examples. CO
Section CAttempt any one part of the following: 10 x 1 = 10
  • a
    Explain alternative design strategies in distributed database design. CO
  • b
    Describe the steps and issues in volved in data allocation in a distributed system. CO
  • a
    Explain in detail the layers of query processing and decomposition. CO
  • b
    Compare centralized and distributed query optimization approach es with examples. CO
  • a
    Discuss different types of transactions and their properties in DDBMS. CO
  • b
    Explain timestamp ordering and optimistic concurrency control mechanisms. CO
  • a
    Explain local and distributed reliability protocols with appropriate examples. CO
  • b
    Discuss parallel database system architectures and the need for load balancing. CO
  • a
    Explain the object-oriented data model with a focus on object i dentity and inheritance. CO
  • b
    Describe distributed object query processing and object storage mechanisms. CO

Question text is extracted from the official AKTU question paper PDF above. Hindi translations are omitted — every question is printed in English in the original paper. Last verified: 2026-08-23.

Distributed Database Systems — Other Year Papers

AKTU Distributed Database Systems PYQs from other sessions

Distributed Database Systems2021-22

More MCA Semester 4 (2024-25) Papers

Other subjects from same semester and session

Pattern Recognition2024-25Neural Network2024-25Soft Computing2024-25Machine Learning2024-25Modern Application Development2024-25Blockchain Architecture2024-25Software Quality Engineering2024-25Computer Graphics And Animation2024-25
View all MCA Semester 4 2024-25 papers →