MCASemester 42021-22Distributed Database SystemsKCA-045
View PDFDownload

Distributed Database Systems (KCA-045) - AKTU Question Paper 2021-22

MCA · Semester 4 · Free PDF Download

This is the official AKTU Distributed Database Systems Previous Year Question Paper for MCA Semester 4, academic session 2021-22. 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:2021-22
University:AKTU / UPTU

Rate this paper

Questions Asked in 2021-22

Distributed Database Systems (KCA-045) — complete question paper

Section AAttempt all q u e s t i o n s i n b r i e f . 2*10 = 20
  • a
    Why distributed databa ses are essential? 1
  • b
    What is transaction log ? What are its functions? 2
  • c
    Explain view serializability. 2
  • d
    How does the concept of an object in object-oriented model differ from the concept of an entity in the ER diagram?
  • e
    Define the concepts of recove rable, cascade less and strict schedules. 4
  • f
    Explain briefly in what way designing an object-oriented da tabase is different from relational database
  • g
    Define Moss Concurrency protocol? 2
  • h
    Differentiate between Bac kward and Forward recovery. 4 (i) Differentiate between 2PL and strict 2PL. 2 (j) What are the types of fai lures in distributed DBMS?
Section BAttempt any three o f t h e f o l l o w i n g : 10*3 = 30
  • a
    Why is recovery in a distributed DBMS more complicated than i n a centralized system?
  • b
    Compare Distributed Deadlock prevention to Distributed Dead lock Avoidance. Explain one scheme of Distributed deadlock Detection and Recovery
  • c
    Discuss the motivation beh ind parallel and distributed databases. 5
  • d
    What is an object identifier? Explain with an example. What are its advantages and disadvantages? ( e ) W h a t p r o b l e m c a n o c c u r i n a distributed system due to the f ailure of link and partitioning of' the network? What are the ways by whi ch recovery can take place?
Section CAttempt any one p a r t o f t h e f o l l o w i n g : 10*1 = 10
  • a
    What are homogenous and heterogeneous database. Give the architecture of heterogeneous d atabase along with some query processing issues
  • b
    Explain briefly about Fragmen tation with suitable examples. 1
  • a
    Justify that three-phase co mmit (3PC) protocol is a non-blocking protocol
  • b
    Discuss the objectives of distributed query processing. Explain the various phrases in distributed query processing in detail
  • a
    Discuss the issues to achieve atomicity in distributed tran saction management system
  • b
    Explain briefly about timesta mp-based concurrency algorithms. 3
  • a
    Describe the followings (i) Consistent Checkpoints (ii) Vot ing protocols
  • b
    Generate an algorithm for synchronous check pointing in a D istributed database system
  • a
    What is the difference between persistent and transient obj ects? How is persistence handled in OO database systems
  • b
    Compare ORDBMS and OODBMS with respect to Data sharing, dat a modelling and data accessing

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 Systems2024-25

More MCA Semester 4 (2021-22) Papers

Other subjects from same semester and session

Data Analytics2021-22Privacy Security In Online Social Media2021-22Computer Graphics And Animation2021-22Mobile Computing2021-22Neural Network2021-22Soft Computing2021-22Modern Application Development2021-22Blockchain Architecture2021-22
View all MCA Semester 4 2021-22 papers →