JNTU
JNTU B.Tech II DATABASE MANAGEMENT SYSTEMS Previous Question Paper (May - 2019 - R13)
Part A is compulsory which carries 25 marks. Answer all questions in Part A. Part B consists of 5 Units. Answer any one full question from each unit.
Part A
What is meant by data abstraction?
Answer
Data abstraction is the process of hiding complex implementation details from the user and providing only the essential features of the data. It allows users to interact with the database through simplified views while the physical storage and internal data structures remain concealed.
Define the terms entity and attributes.
Answer
An entity is a distinct object or concept in the real world, such as a person, place, or event, about which data is stored in a database. An attribute is a property or characteristic that describes an entity, such as a name, age, or ID number.
Explain the selection and projection operations.
Answer
Sign in to view the complete answer paper.
Write brief notes on NULL values.
Answer
Sign in to view the complete answer paper.
Explain first normal form?
Answer
Sign in to view the complete answer paper.
Write short notes on inclusion dependencies.
Answer
Sign in to view the complete answer paper.
What is meant by atomicity?
Answer
Sign in to view the complete answer paper.
What is meant by recoverability?
Answer
Sign in to view the complete answer paper.
What are the clustered indexes?
Answer
Sign in to view the complete answer paper.
What is meant by linear hashing?
Answer
Sign in to view the complete answer paper.
Part B
Discuss about querying relational data.
Answer
Sign in to view the complete answer paper.
Describe the history of database systems.
Answer
Sign in to view the complete answer paper.
Explain the AND, OR and NOT logical connectives with examples.
Answer
Sign in to view the complete answer paper.
Discuss about complex integrity constraints in SQL.
Answer
Sign in to view the complete answer paper.
Explain about dependency preserving decomposition.
Answer
Sign in to view the complete answer paper.
Explain third normal form and fifth normal form.
Answer
Sign in to view the complete answer paper.
Discuss about time stamp based protocols.
Answer
Sign in to view the complete answer paper.
Discuss about remote backup systems.
Answer
Sign in to view the complete answer paper.
Explain about Dynamic index structure.
Answer
Sign in to view the complete answer paper.
Discuss about static hashing and extendable hashing.
Answer
Sign in to view the complete answer paper.