FirstRanker Logo

FirstRanker.com - FirstRanker's Choice is a hub of Question Papers & Study Materials for B-Tech, B.E, M-Tech, MCA, M.Sc, MBBS, BDS, MBA, B.Sc, Degree, B.Sc Nursing, B-Pharmacy, D-Pharmacy, MD, Medical, Dental, Engineering students. All services of FirstRanker.com are FREE

📱

Get the MBBS Question Bank Android App

Access previous years' papers, solved question papers, notes, and more on the go!

Install From Play Store

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

This post was last modified on 17 March 2023

--- Content provided by FirstRanker.com ---

Code No: 845AD

JAWAHARLAL NEHRU TECHNOLOGICAL UNIVERSITY HYDERABAD

MCA V Semester Examinations, October/ November - 2020

--- Content provided by⁠ FirstRanker.com ---


DISTRIBUTED DATABASES



--- Content provided by‌ FirstRanker.com ---

Time: 2 Hours




--- Content provided by​ FirstRanker.com ---






--- Content provided by FirstRanker.com ---





Max. Marks: 75

--- Content provided by FirstRanker.com ---


Answer any five questions

All questions carry equal marks

--- Content provided by FirstRanker.com ---

----



1.a)

--- Content provided by⁠ FirstRanker.com ---


Explain about Reference Architecture for Distributed Databases.

b)

--- Content provided by‍ FirstRanker.com ---

Write short note on Distribution Transparency.




--- Content provided by FirstRanker.com ---






--- Content provided by​ FirstRanker.com ---

[7+8]


2.a)

--- Content provided by⁠ FirstRanker.com ---

Explain about Parametric Queries in distributed database.

b)

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

--- Content provided by‍ FirstRanker.com ---



3.a)

Explain Timestamp based protocol in distributed databases.

--- Content provided by​ FirstRanker.com ---


b)

Explain Optimistic Methods for Distributed Concurrency Control.

--- Content provided by​ FirstRanker.com ---



[7+8]

used

--- Content provided by⁠ FirstRanker.com ---



4.a)

Explain about the following in Distributed Data base:

--- Content provided by⁠ FirstRanker.com ---




i) Check points

--- Content provided by‍ FirstRanker.com ---





ii) Cold Restart.

--- Content provided by‌ FirstRanker.com ---


b)

Explain bout authorization and protection in distributed database.

--- Content provided by FirstRanker.com ---



[7+8]


--- Content provided by FirstRanker.com ---

5.a)

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

b)

--- Content provided by FirstRanker.com ---


Explain about Object Management Architecture CORBA.



--- Content provided by‍ FirstRanker.com ---



[7+8]


--- Content provided by​ FirstRanker.com ---






--- Content provided by‍ FirstRanker.com ---

6.a)

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

b)

--- Content provided by‌ FirstRanker.com ---


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


--- Content provided by‌ FirstRanker.com ---






--- Content provided by‌ FirstRanker.com ---






--- Content provided by​ FirstRanker.com ---






--- Content provided by FirstRanker.com ---



[7+8]


--- Content provided by‍ FirstRanker.com ---

7.a)

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

b)

--- Content provided by⁠ FirstRanker.com ---


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



--- Content provided by‌ FirstRanker.com ---

[7+8]


8.a)

--- Content provided by​ FirstRanker.com ---

Explain two-phase locking protocol in distributed database.

b)

Explain Deadlock prevention in distributed databases.

--- Content provided by​ FirstRanker.com ---






--- Content provided by⁠ FirstRanker.com ---



[7+8]


--- Content provided by‍ FirstRanker.com ---


---oo0oo---