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 question paper of DATABASE MANAGEMENT SYSTEMS from JNTU for B.Tech MECT-MCT-MEM III I, February - 2022, R16.

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

Other papers in DATABASE MANAGEMENT SYSTEMS

Loading Question Papers

Fetching data from database...