STUPIDSID
1 (a)
Explain Mixed fragmentation with the help of an example.
7 M
1 (b)
What are distributed systems ? List two advantages and disadvantages of
distributed system over centralized one? Also explain parallelism and transparency.
7 M
2 (a)
Explain Top Down Design Process for Distributed Database Design.
7 M
2 (b)
Explain following in context of Relational algebra :
1. Selection 2. Natural Join 3. Intersection
1. Selection 2. Natural Join 3. Intersection
7 M
2 (c)
Explain the terms transparency and concurrency with respect to DDBMS. Also Explain layers of transparency.
7 M
3 (a)
Write a note on components of DDBMS.
7 M
3 (b)
Explain loosely coupled system and tightly coupled system.
7 M
3 (c)
What are various types of networks? Explain in brief.
7 M
3 (d)
Explain Transaction Management in DDBMS.
7 M
4 (a)
What do you mean by two phase locking? How it is different from strict two
phase locking ? Explain in brief.
7 M
4 (b)
What is replication? Explain different types of replication techniques?
7 M
4 (c)
Discuss the problems of query optimization.
7 M
4 (d)
Write a note on concurrency control.
7 M
5 (a)
Given a global relation
EMP(EMPNUM,NAME,SAL,TAX,MGRNUM,DEPTNUM)
Write the mixed fragmentation de_nition and fragmentation tree of relation EMP.
EMP(EMPNUM,NAME,SAL,TAX,MGRNUM,DEPTNUM)
Write the mixed fragmentation de_nition and fragmentation tree of relation EMP.
7 M
5 (b)
Write short note on: Reliability in Distributed DBMS
7 M
5 (c)
List the steps of Query Decomposition. Explain any one of them.
7 M
5 (d)
Explain the Client server architecture for Distributed DBMS with figure
7 M
More question papers from Distributed Database Application & System