JAWAHARLAL NEHRU TECHNOLOGICAL UNIVERSITY HYDERABAD

JAWAHARLAL NEHRU TECHNOLOGICAL UNIVERSITY HYDERABAD B.Tech III Year DISTRIBUTED DATABASES Previous Question Paper (August/September - 2024 - R18)

B.Tech | III Year | I Semester | R18 | August/September - 2024

Answer PaperPaper Code: 155AYMaximum Marks: 75Time: 3 Hours

Note: Part A is compulsory (25 Marks). In Part B, answer any one question from each unit (50 Marks).

Part A

125 marks
a

What is distributed database system?

2 marks

Answer

A Distributed Database System (DDBS) is a collection of multiple, logically interrelated databases distributed over a computer network. The system is managed by a Distributed Database Management System (DDBMS), which ensures that the distribution is transparent to the user, meaning the user perceives the system as a single, centralized database.
b

Explain briefly about peer to peer systems.

3 marks

Answer

A Peer-to-Peer (P2P) system is a decentralized network architecture where each node (peer) acts as both a client and a server. Unlike client-server models, there is no central authority or server. Peers share resources, such as files, processing power, or storage, directly with one another. These systems are highly scalable and resilient to single-point failures, as the removal of one peer does not disrupt the entire network.
c

Define semi join operation.

2 marks

Answer

Sign in to view the complete answer paper.

d

Write the benefits of normalization.

3 marks

Answer

Sign in to view the complete answer paper.

e

Define dead lock.

2 marks

Answer

Sign in to view the complete answer paper.

f

Write the ACID properties of transaction.

3 marks

Answer

Sign in to view the complete answer paper.

g

Define mutual consistency.

2 marks

Answer

Sign in to view the complete answer paper.

h

List out communication failures in distributed databases.

3 marks

Answer

Sign in to view the complete answer paper.

i

Define object and class.

2 marks

Answer

Sign in to view the complete answer paper.

j

What is object migration?

3 marks

Answer

Sign in to view the complete answer paper.

Part B

210 marks
a

Explain the design issues in Distributed data bases.

5 marks

Answer

Sign in to view the complete answer paper.

b

Discuss about vertical fragmentation techniques.

5 marks

Answer

Sign in to view the complete answer paper.

OR
310 marks
a

Explain allocation methods in distributed data bases.

5 marks

Answer

Sign in to view the complete answer paper.

b

Write the steps for distributed data base design and briefly discuss.

5 marks

Answer

Sign in to view the complete answer paper.

410 marks
a

Explain query processing in distributed DBMS with an example.

5 marks

Answer

Sign in to view the complete answer paper.

b

What do you mean by the term localization of distributed data? Explain.

5 marks

Answer

Sign in to view the complete answer paper.

OR
510 marks
a

Explain distributed query optimization algorithm.

5 marks

Answer

Sign in to view the complete answer paper.

b

Give a detailed note on query decomposition.

5 marks

Answer

Sign in to view the complete answer paper.

610 marks
a

Explain flat and nested transaction in detail.

5 marks

Answer

Sign in to view the complete answer paper.

b

Describe distributed two-phase locking protocol.

5 marks

Answer

Sign in to view the complete answer paper.

OR
710 marks
a

Discuss about optimization concurrency control algorithm.

5 marks

Answer

Sign in to view the complete answer paper.

b

Explain deadlock prevention techniques.

5 marks

Answer

Sign in to view the complete answer paper.

810 marks
a

Explain the components of distributed reliability protocols.

5 marks

Answer

Sign in to view the complete answer paper.

b

Describe three phase commit protocol for distributed reliability.

5 marks

Answer

Sign in to view the complete answer paper.

OR
910 marks
a

Discuss eager centralized replication protocols.

5 marks

Answer

Sign in to view the complete answer paper.

b

Compare Mutual Consistency versus Transaction Consistency.

5 marks

Answer

Sign in to view the complete answer paper.

1010 marks
a

Explain vertical class partitioning.

5 marks

Answer

Sign in to view the complete answer paper.

b

Describe object query processing architecture.

5 marks

Answer

Sign in to view the complete answer paper.

OR
1110 marks
a

Give a detailed note pointer swizzling.

5 marks

Answer

Sign in to view the complete answer paper.

b

Explain Transactions Management in Object DBMSs.

5 marks

Answer

Sign in to view the complete answer paper.

About this paper

This page contains the solved question paper with answers of DISTRIBUTED DATABASES from JAWAHARLAL NEHRU TECHNOLOGICAL UNIVERSITY HYDERABAD for B.Tech CSE III Year I Semester, August/September - 2024, R18.

For the question paper without answers, switch to the Question Paper tab.

Other papers in DISTRIBUTED DATABASES

Loading Question Papers

Fetching data from database...