Download JNTUH MCA 5th Sem R17 2020 November 845AD Distributed Databases Question Paper

Download JNTUH (Jawaharlal nehru technological university) MCA (Master of Computer Applications) 5th Sem (Fifth Semester) Regulation-R17 2020 November 845AD Distributed Databases Previous Question Paper

S OCT 2020

R17

Code No: 845AD

JAWAHARLAL NEHRU TECHNOLOGICAL UNIVERSITY HYDERABAD

MCA V Semester Examinations, October/ November - 2020

DISTRIBUTED DATABASES



Time: 2 Hours













Max. Marks: 75

Answer any five questions

All questions carry equal marks

----



1.a)

Explain about Reference Architecture for Distributed Databases.

b)

Write short note on Distribution Transparency.









[7+8]


2.a)

Explain about Parametric Queries in distributed database.

b)

Explain about grouping and aggregate function evaluation in distributed database. [7+8]


3.a)

Explain Timestamp based protocol in distributed databases.

b)

Explain Optimistic Methods for Distributed Concurrency Control.



[7+8]

used


4.a)

Explain about the following in Distributed Data base:



i) Check points





ii) Cold Restart.

b)

Explain bout authorization and protection in distributed database.



[7+8]


5.a)

Explain about various query processing layers in Distributed Multi-DBMS.

b)

Explain about Object Management Architecture CORBA.





[7+8]







6.a)

Define Distributed Data base and explain the various features of distributed database.

b)

What is meant by data fragmentation? Explain the Vertical Fragmentation with an
example.



















[7+8]


7.a)

List out the different components that are used by query optimizer. Explain.

b)

Discuss how an optimization graph can be drawn for a given query.



[7+8]


8.a)

Explain two-phase locking protocol in distributed database.

b)

Explain Deadlock prevention in distributed databases.







[7+8]



---oo0oo---