JAWAHARLAL NEHRU TECHNOLOGICAL UNIVERSITY HYDERABAD
JAWAHARLAL NEHRU TECHNOLOGICAL UNIVERSITY HYDERABAD B.Tech II DATABASE MANAGEMENT SYSTEMS Previous Question Paper (September/October - 2023 - R16)
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
Define data independence.
Answer
Data independence is the ability to modify the schema at one level of a database system without requiring changes to the schema at the next higher level. It is categorized into physical data independence (modifying physical storage without affecting the conceptual schema) and logical data independence (modifying the conceptual schema without affecting external views).
Illustrate class hierarchies in ER model.
Answer
Class hierarchies (or generalization/specialization) represent an IS-A relationship where a subclass inherits attributes and relationships from a superclass. For example, a superclass Employee can have subclasses Manager and Engineer. The subclasses share the attributes of the superclass while possessing their own specific attributes.
What is an active database?
Answer
Sign in to view the complete answer paper.
Give the basic form of SQL query.
Answer
Sign in to view the complete answer paper.
Define functional dependency.
Answer
Sign in to view the complete answer paper.
List Armstrong’s inference rules.
Answer
Sign in to view the complete answer paper.
What is an intention lock?
Answer
Sign in to view the complete answer paper.
Give failure classification.
Answer
Sign in to view the complete answer paper.
What is a heap file?
Answer
Sign in to view the complete answer paper.
What is multi-level indexing?
Answer
Sign in to view the complete answer paper.
Part B
What are the functionalities and responsibilities of database administrator?
Answer
Sign in to view the complete answer paper.
Compare database system with information retrieval system.
Answer
Sign in to view the complete answer paper.
What is an integrity constraint? Explain various types of integrity constraints and their enforcement by DBMS.
Answer
Sign in to view the complete answer paper.
Consider the following database schema to write queries in Relational Algebra: Supplier(sno, sname, city), Parts(Pid, name, color), Supply(sno, pid, price)
Find the names of the parts supplied by Hyderabadi suppliers.
Answer
Sign in to view the complete answer paper.
Find the names of the suppliers who supply Blue colored blenders.
Answer
Sign in to view the complete answer paper.
Find the names of the suppliers who supply Grills for cheapest price.
Answer
Sign in to view the complete answer paper.
Demonstrate the use of aggregate operators in SQL.
Answer
Sign in to view the complete answer paper.
What is a nested query? What are its advantages? Explain with an example.
Answer
Sign in to view the complete answer paper.
Discuss the problems caused due to redundancy and suggest mechanisms to reduce redundancy.
Answer
Sign in to view the complete answer paper.
Compare and contrast 3NF with BCNF.
Answer
Sign in to view the complete answer paper.
With examples, explain the properties of decomposition.
Answer
Sign in to view the complete answer paper.
Compare two phase locking protocol with time stamp based protocol for concurrency control.
Answer
Sign in to view the complete answer paper.
Explain time-stamp based protocol for concurrency control.
Answer
Sign in to view the complete answer paper.
How to implement transaction atomicity?
Answer
Sign in to view the complete answer paper.
Demonstrate redo and undo operations in recovery algorithm.
Answer
Sign in to view the complete answer paper.
How does data get stored on a magnetic disk? Explain with a suitable diagram.
Answer
Sign in to view the complete answer paper.
Explain search operation of a B+ tree with an illustrative example.
Answer
Sign in to view the complete answer paper.
Describe extendible hashing as a dynamic indexing structure with necessary data.
Answer
Sign in to view the complete answer paper.