JNTU

JNTU B.Tech III DATABASE MANAGEMENT SYSTEMS Previous Question Paper (February - 2022 - R16)

B.Tech | III | I | R16 | February - 2022

Answer PaperPaper Code: 135CAMaximum Marks: 75Time: 3 Hours

Answer any five questions

All questions carry equal marks

Main

115 marks
a

Identify the main components in a DBMS and briefly explain what they do.

8 marks

Answer

A Database Management System (DBMS) consists of several key components that work together to manage data efficiently:

  • Query Processor: Acts as the interface for users, parsing, optimizing, and executing queries to retrieve or update data.
  • Database Manager: The core component that controls access to the stored data, ensuring integrity and security.
  • File Manager: Manages the allocation of space on disk storage and the data structures used to represent information.
  • Data Manager: Handles the interface between user-submitted data and the stored data, managing concurrency control and recovery.
  • Data Dictionary: A repository containing metadata, such as schema definitions, constraints, and user access rights.
  • Storage Manager: Responsible for the actual storage of data on physical media and managing the buffer pool.
b

Explain Data Mining architecture.

7 marks

Answer

Data Mining architecture is designed to extract patterns from large datasets through a multi-layered process. The primary components include:

  • Database/Data Warehouse Server: The foundation that stores the raw data, which is cleaned and integrated from various sources.
  • Knowledge Base: Stores domain knowledge or constraints that guide the search process and evaluate the interestingness of discovered patterns.
  • Data Mining Engine: The core module consisting of algorithms for tasks like classification, clustering, association, and regression.
  • Pattern Evaluation Module: Works with the mining engine to focus on interesting patterns based on user-defined thresholds or metrics.
  • User Interface: The interactive layer that allows the user to specify mining tasks, view results, and visualize discovered patterns.
2

Define all the variations of the join operation. Why is the join operation given special attention? Cannot we express every join operation in terms of cross-product, selection, and projection?

15 marks

Answer

Sign in to view the complete answer paper.

3

What aggregate operators does SQL support? Explain with example queries.

15 marks

Answer

Sign in to view the complete answer paper.

4

Define 1NF, 2NF, 3NF, and BCNF. What is the motivation for putting a relation in BCNF? What is the motivation for 3NF?

15 marks

Answer

Sign in to view the complete answer paper.

5

Consider a relation R with five attributes ABCDE. You are given the following dependencies: A→B, BE→B, and BD → A.

15 marks
a

List all keys for R.

5 marks

Answer

Sign in to view the complete answer paper.

b

Is R in 3NF?

5 marks

Answer

Sign in to view the complete answer paper.

c

Is R in BCNF? Justify.

5 marks

Answer

Sign in to view the complete answer paper.

6

What is a locking protocol? Describe the Strict Two-Phase Locking (Strict 2PL) protocol. What can you say about the schedules allowed by this protocol?

15 marks

Answer

Sign in to view the complete answer paper.

7

Describe and compare deadlock detection and deadlock prevention schemes. Why is detection schemes more commonly used?

15 marks

Answer

Sign in to view the complete answer paper.

8

What is a file organization? What is an index? What is the relationship between files and indexes? Can we have several indexes on a single file of records? Can an index itself store data records (i.e., act as a file)?

15 marks

Answer

Sign in to view the complete answer paper.

About this paper

This page contains the solved question paper with answers of DATABASE MANAGEMENT SYSTEMS from JNTU for B.Tech CE III I, February - 2022, R16.

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

Other papers in DATABASE MANAGEMENT SYSTEMS

Loading Question Papers

Fetching data from database...