JAWAHARLAL NEHRU TECHNOLOGICAL UNIVERSITY HYDERABAD
JAWAHARLAL NEHRU TECHNOLOGICAL UNIVERSITY HYDERABAD B.Tech III DATABASE MANAGEMENT SYSTEMS Previous Question Paper (August/September - 2024 - 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 schema.
Answer
A schema is the logical structure or blueprint of a database that defines the organization of data, the relationships between data elements, and the constraints applied to the data. It describes how data is stored and accessed without specifying the actual data instances.
What is a data model?
Answer
A data model is a collection of conceptual tools, notations, and rules used to describe the data, data relationships, data semantics, and consistency constraints of a database. It provides a way to represent the real-world environment in a structured format, serving as the foundation for database design.
What is an active database?
Answer
Sign in to view the complete answer paper.
What is the need of outer join operation?
Answer
Sign in to view the complete answer paper.
List the properties of decomposition.
Answer
Sign in to view the complete answer paper.
What is meant by multi valued dependency?
Answer
Sign in to view the complete answer paper.
Define transaction.
Answer
Sign in to view the complete answer paper.
What is the benefit of early lock release?
Answer
Sign in to view the complete answer paper.
What is a clustered index?
Answer
Sign in to view the complete answer paper.
List the operations preferred on heap files.
Answer
Sign in to view the complete answer paper.
Part B
Describe database architecture with a neat diagram.
Answer
Sign in to view the complete answer paper.
Justify the use of weak entity sets in database design.
Answer
Sign in to view the complete answer paper.
Demonstrate the steps in logical database design.
Answer
Sign in to view the complete answer paper.
Is Relational algebra a procedural DML? Justify your answer.
Answer
Sign in to view the complete answer paper.
Contrast tuple relational calculus with domain relational calculus.
Answer
Sign in to view the complete answer paper.
Consider the following database schema to write queries in SQL:
Sailors(sid, sname, age, rating)
Boats(bid, bname, bcolor)
Reserves(sid, bid, day)
Find the names of the sailors who have reserved a red boat.
Answer
Sign in to view the complete answer paper.
Find the colours of the boats reserved by ‘Ramu’.
Answer
Sign in to view the complete answer paper.
Find the sailors who have reserved atleast two boats.
Answer
Sign in to view the complete answer paper.
Find the name of the youngest sailor.
Answer
Sign in to view the complete answer paper.
Discuss the problems caused by redundancy and the significance of schema refinement.
Answer
Sign in to view the complete answer paper.
Compare and contrast 2NF with 3NF.
Answer
Sign in to view the complete answer paper.
With an example set of functional dependency explain attribute closure computation.
Answer
Sign in to view the complete answer paper.
Differentiate between serial schedule and serializable schedule.
Answer
Sign in to view the complete answer paper.
With example schedule, explain two phase locking protocol for concurrency control.
Answer
Sign in to view the complete answer paper.
Discuss a recovery algorithm for handling recovery of system with concurrent transactions.
Answer
Sign in to view the complete answer paper.
With relevant data records, demonstrate bulk loading of B+ tree index structure.
Answer
Sign in to view the complete answer paper.
Explain the concept of cylinder in disk organization.
Answer
Sign in to view the complete answer paper.
Compare sparse index with dense index.
Answer
Sign in to view the complete answer paper.