JAWAHARLAL NEHRU TECHNOLOGICAL UNIVERSITY HYDERABAD
JAWAHARLAL NEHRU TECHNOLOGICAL UNIVERSITY HYDERABAD B.Tech III DATABASE MANAGEMENT SYSTEMS Previous Question Paper (November/December - 2018 - R16)
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. Each question carries 10 marks.
Part A
Define the terms: Relational Databases, Tables.
Answer
Relational Databases are collections of data items organized as a set of formally-described tables from which data can be accessed or reassembled in many different ways without having to reorganize the database tables. A Table is a collection of related data entries consisting of rows (tuples) and columns (attributes) that represent a specific entity or relationship.
Write down the applications of DBMS.
Answer
Applications of DBMS include: 1) Banking: for customer information, accounts, and transaction management. 2) E-commerce: for managing product catalogs, inventory, and order processing. 3) Healthcare: for maintaining patient records and medical history. 4) Education: for student information systems and course management.
Define Trigger and give an example.
Answer
Sign in to view the complete answer paper.
Write down the various aggregate operators of SQL.
Answer
Sign in to view the complete answer paper.
Mention the properties of decomposition.
Answer
Sign in to view the complete answer paper.
Define BCNF. Write down its basic properties.
Answer
Sign in to view the complete answer paper.
Define multiple granularity.
Answer
Sign in to view the complete answer paper.
What do you mean by 2PL?
Answer
Sign in to view the complete answer paper.
Differentiate Extendible vs. Linear Hashing.
Answer
Sign in to view the complete answer paper.
What are the advantages and disadvantages of B+ trees?
Answer
Sign in to view the complete answer paper.
Part B
Explain the Database system structure.
Answer
Sign in to view the complete answer paper.
Explain various DDL and DML commands.
Answer
Sign in to view the complete answer paper.
Define ER model and explain the following kinds of constraints that can be specified in the ER diagram, and give an example of each: i) key constraint ii) participation constraint.
Answer
Sign in to view the complete answer paper.
How to destroy and alter tables in a DBMS?
Answer
Sign in to view the complete answer paper.
Explain about the following:
Domain relational calculus.
Answer
Sign in to view the complete answer paper.
Specifying foreign key constraints in SQL with an example.
Answer
Sign in to view the complete answer paper.
Consider the following relations: Sailors (sid, sname, rating, age), Boats (bid, bname, color), Reserves (sid, bid, day). Write the statements in Relational Algebra, Relational Calculus, Domain Relational Calculus and SQL for the following questions.
Find the names of sailors who have reserved a Red boat.
Answer
Sign in to view the complete answer paper.
Find the names of sailors who have reserved at least one boat.
Answer
Sign in to view the complete answer paper.
Find the names of sailors who have reserved a Red and a Green boat.
Answer
Sign in to view the complete answer paper.
Find the names of sailors who have reserved a Red or a White boat.
Answer
Sign in to view the complete answer paper.
Find the names of sailors who have reserved all boats.
Answer
Sign in to view the complete answer paper.
When is the decomposition of a relation schema R into two relation schemas X and Y said to be lossless-join decomposition? Why is this property so important? Give a necessary and sufficient condition to test whether a decomposition is lossless-join.
Answer
Sign in to view the complete answer paper.
Explain 3NF with examples.
Answer
Sign in to view the complete answer paper.
Discuss the need for schema refinement. Explain the fourth and fifth normal form and inclusion dependencies.
Answer
Sign in to view the complete answer paper.
Discuss the impact of early lock release and logical undo operations in recovery system.
Answer
Sign in to view the complete answer paper.
Explain about Concurrent execution of transactions.
Answer
Sign in to view the complete answer paper.
Write and explain the Time stamped and optimistic concurrency control algorithms.
Answer
Sign in to view the complete answer paper.
State and explain various file organisation methods. Give suitable examples to each them.
Answer
Sign in to view the complete answer paper.
Discuss insert, delete, search operations on and B+ trees.
Answer
Sign in to view the complete answer paper.
What are the Pros and Cons of ISAM?
Answer
Sign in to view the complete answer paper.