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 R15 2020 November 825AC Distributed Databases Question Paper

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

This post was last modified on 17 March 2023

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

Code No: 825AC

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---