Jawaharlal Nehru Technological University, Hyderabad MCA-V Semester Supplementary Examinations July/August 2010 ADVANCED DATABASES Question paper

Code No: 58

Time: 3hours Max.Marks:60

Answer any Five questions
All questions carry equal Marks

1.a) What is a database? Explain a distributed database system and its importance in the current scenario of information technology.
b) Write about the relational data languages with examples.

2.a) Describe the architectural models for Distributed DBMS.
b) Explain the various alternative design strategies.

3.a) Explain the various layers of query processing.
b) Write about localization of distributed data.

4.a) What is meant by query optimization? Explain the functionality of query optimization in distributed databases scenario.
b) Explain distributed query optimization algorithms.

5.a) Enumerate the different types of transactions with a suitable example.
b) Explain how deadlocks are managed in a distributed database.

6.a) Write about local & distributed reliability protocols.
b) Explain the parallel exception problems.

7.a) Describe the object distributed design.
b) Explain about the distributed object storage.

8.a) Explain about persistent programming languages.
b) Compare and contrast OODBMS and ORDBMS.