GTU Distributed Database Application & System - December 2014 Exam Question Paper

GTU Information Technology (Semester 7)
Distributed Database Application & System
December 2014

Total marks: --
Total time: --

INSTRUCTIONS
(1) Assume appropriate data and state your reasons
(2) Marks are given to the right of every question
(3) Draw neat diagrams wherever necessary

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

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.

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

SPONSORED ADVERTISEMENTS