MCASemester 42022-23Distributed Database SystemKCA045
View PDFDownload

Distributed Database System (KCA045) - AKTU Question Paper 2022-23

MCA · Semester 4 · Free PDF Download

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

Rate this paper

Questions Asked in 2022-23

Distributed Database System (KCA045) — complete question paper

Section AAttempt all questions in brief. 2 x 10 = 20
  • a
    List features of relational data model
  • b
    What is Transparencies in distributed database?
  • c
    Differentiate between homogenous & heterogeneous DDBMS
  • d
    Draw transaction state diagram
  • e
    Differentiate between shared lock & exclusive lock
  • f
    Discuss the role of client in client/server system
  • g
    What are the functions of Transaction Manager?
  • h
    What do you understand by semi join? (i) What are the different strategies for designing distributed database? (j) Differentiate between full & partial replication in DDBMS
Section BAttempt any three of the following: 10 x 3 = 30
  • a
    Discuss the distributed database system? Also explain the promises of DDBS
  • b
    Explain query processing. Also explain the layers of query processing
  • c
    Discuss the Transaction. Explain ACID properties with an example
  • d
    Discuss various reasons for failures in distributed systems
  • e
    Briefly explain fundamental object concepts and mod els. Also explain abstract data types
Section CAttempt any one part of the following: 10 x 1 = 10
  • a
    Discuss various technical problems that need to be resolved to realize the full potential of DDBMS
  • b
    Give a brief account of architectural models for distributed DBMS
  • a
    Briefly explain the objectives of query processing
  • b
    Discuss the query optimization? Explain distributed cost model with an example
  • b
    Explain deadlock handling. Discuss various deadlock avoidance algorithms
  • a
    Explain the working of t wo phase commit protocol of distributed transactions
  • b
    Explain general architecture of a parallel database system and shared memory architecture
  • a
    Describe following terms with reference to object oriented data model: (i) Inheritance. (ii) Object identity
  • b
    Write a short note on OODBMS. Also compare between OODBMS and ORDBMS

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.

More MCA Semester 4 (2022-23) Papers

Other subjects from same semester and session

Neural Network2022-23Blockchain Architecture2022-23Internet Of Things2022-23Modern Applicatioin Development2022-23
View all MCA Semester 4 2022-23 papers →