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) — extracted question text
Section AAttempt all questions in brief. 2 x 10 = 20
- aList features of relational data model
- bWhat is Transparencies in distributed database?
- cDifferentiate between homogenous & heterogeneous DDBMS
- dDraw transaction state diagram
- eDifferentiate between shared lock & exclusive lock
- fDiscuss the role of client in client/server system
- gWhat are the functions of Transaction Manager?
- hWhat 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
- aDiscuss the distributed database system? Also explain the promises of DDBS
- bExplain query processing. Also explain the layers of query processing
- cDiscuss the Transaction. Explain ACID properties with an example
- dDiscuss various reasons for failures in distributed systems
- eBriefly explain fundamental object concepts and mod els. Also explain abstract data types
Section CAttempt any one part of the following: 10 x 1 = 10
- aDiscuss various technical problems that need to be resolved to realize the full potential of DDBMS
- bGive a brief account of architectural models for distributed DBMS
- aBriefly explain the objectives of query processing
- bDiscuss the query optimization? Explain distributed cost model with an example
- bExplain deadlock handling. Discuss various deadlock avoidance algorithms
- aExplain the working of t wo phase commit protocol of distributed transactions
- bExplain general architecture of a parallel database system and shared memory architecture
- aDescribe following terms with reference to object oriented data model: (i) Inheritance. (ii) Object identity
- bWrite a short note on OODBMS. Also compare between OODBMS and ORDBMS
Question text is extracted from the official AKTU question paper PDF above. Check the original PDF for equations, diagrams and complete wording. Extracted: 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 →