JAWAHARLAL NEHRU TECHNOLOGICAL UNIVERSITY HYDERABAD

JAWAHARLAL NEHRU TECHNOLOGICAL UNIVERSITY HYDERABAD B.Tech IV DISTRIBUTED DATABASES Previous Question Paper (January/February - 2023 - R18)

B.Tech | IV | I | R18 | January/February - 2023

Answer PaperPaper Code: 157BJMaximum Marks: 75Time: 3 Hours

Note: i) Question paper consists of Part A, Part B. ii) Part A is compulsory, which carries 25 marks. In Part A, Answer all questions. iii) In Part B, Answer any one question from each unit. Each question carries 10 marks and may have a, b as sub questions.

Part A

1a

What is a distributed database management system?

2 marks

Answer

A Distributed Database Management System (DDBMS) is a software system that manages a distributed database while making the distribution transparent to the user. It enables the management of data stored across multiple physically dispersed sites connected by a computer network, ensuring that the collection of data appears as a single, logically integrated database to the end-user or application.

1b

What is network transparency?

3 marks

Answer

Network transparency, also known as distribution transparency, is a property of a distributed database system that allows users and applications to operate on data without needing to know the physical location of the data or the network topology of the system. It ensures that the distributed nature of the database is hidden from the end-user.

Key aspects include:

  • Location transparency: Users can access data using a logical name without specifying the node or site where the data resides.
  • Naming transparency: A unique global name is provided for all data objects, ensuring that the same name refers to the same object regardless of the user's location.
  • Communication transparency: The system automatically handles the complexities of network protocols and data transmission between sites, making the network infrastructure invisible to the user.
1c

State the need for Query decomposition.

2 marks

Answer

Sign in to view the complete answer paper.

1d

What are the objectives of query processing?

3 marks

Answer

Sign in to view the complete answer paper.

1e

Define a wait-free graph.

2 marks

Answer

Sign in to view the complete answer paper.

1f

Differentiate between basic TO and Multiversion TO algorithm.

3 marks

Answer

Sign in to view the complete answer paper.

1g

Define abort and commit commands.

2 marks

Answer

Sign in to view the complete answer paper.

1h

What are the two rules that govern the global termination of a transaction?

3 marks

Answer

Sign in to view the complete answer paper.

1i

Define the term Composition and give an example with respect to DDBMS.

2 marks

Answer

Sign in to view the complete answer paper.

1j

Discuss about sub classing and inheritance in DDBMS.

3 marks

Answer

Sign in to view the complete answer paper.

Part B

2

Explain the components of a Distributed DBMS with a neat diagram.

10 marks

Answer

Sign in to view the complete answer paper.

OR
310 marks
a

Discuss the design issues of Distribute Databases.

5 marks

Answer

Sign in to view the complete answer paper.

b

Present a formal algorithm for horizontal fragmentation with an illustrative example.

5 marks

Answer

Sign in to view the complete answer paper.

4

Illustrate the query processing problem considering an example engineering database schema.

10 marks

Answer

Sign in to view the complete answer paper.

OR
5

Explain in detail about localization of distributed data with relevant diagrams.

10 marks

Answer

Sign in to view the complete answer paper.

610 marks
a

Provide an overview of types of the transaction models.

5 marks

Answer

Sign in to view the complete answer paper.

b

Explain distributed 2PL algorithm with an example.

5 marks

Answer

Sign in to view the complete answer paper.

OR
710 marks
a

Write down the algorithm for basic Time Stamp Ordering algorithm and explain in brief.

5 marks

Answer

Sign in to view the complete answer paper.

b

Explain about distributed deadlock detection algorithm in brief.

5 marks

Answer

Sign in to view the complete answer paper.

8

Discuss the reasons for failures in distributed systems and explain the types of failures in distributed DBMS.

10 marks

Answer

Sign in to view the complete answer paper.

OR
9

Give an overview of distributed reliability protocols.

10 marks

Answer

Sign in to view the complete answer paper.

10

Explain the following terms with respect to Distributed Object Database Management:

10 marks
a

Horizontal Class Partitioning

6 marks

Answer

Sign in to view the complete answer paper.

b

Vertical Class Partitioning.

4 marks

Answer

Sign in to view the complete answer paper.

OR
1110 marks
a

Compare OODBMS and ORDBMS.

4 marks

Answer

Sign in to view the complete answer paper.

b

Outline Persistent Programming languages in details.

6 marks

Answer

Sign in to view the complete answer paper.

About this paper

This page contains the question paper of DISTRIBUTED DATABASES from JAWAHARLAL NEHRU TECHNOLOGICAL UNIVERSITY HYDERABAD for B.Tech IT IV I, January/February - 2023, R18.

For the solved question paper with answers, switch to the Answer Paper tab.

Other papers in DISTRIBUTED DATABASES

Loading Question Papers

Fetching data from database...