JNTU
JNTU B.Tech III DATABASE MANAGEMENT SYSTEMS Previous Question Paper (February - 2022 - R16)
Answer any five questions
All questions carry equal marks
Main
Identify the main components in a DBMS and briefly explain what they do.
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.
Explain Data Mining architecture.
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.
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?
Answer
Sign in to view the complete answer paper.
What aggregate operators does SQL support? Explain with example queries.
Answer
Sign in to view the complete answer paper.
Define 1NF, 2NF, 3NF, and BCNF. What is the motivation for putting a relation in BCNF? What is the motivation for 3NF?
Answer
Sign in to view the complete answer paper.
Consider a relation R with five attributes ABCDE. You are given the following dependencies: A→B, BE→B, and BD → A.
List all keys for R.
Answer
Sign in to view the complete answer paper.
Is R in 3NF?
Answer
Sign in to view the complete answer paper.
Is R in BCNF? Justify.
Answer
Sign in to view the complete answer paper.
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?
Answer
Sign in to view the complete answer paper.
Describe and compare deadlock detection and deadlock prevention schemes. Why is detection schemes more commonly used?
Answer
Sign in to view the complete answer paper.
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)?
Answer
Sign in to view the complete answer paper.