JAWAHARLAL NEHRU TECHNOLOGICAL UNIVERSITY HYDERABAD
JAWAHARLAL NEHRU TECHNOLOGICAL UNIVERSITY HYDERABAD B.Tech II DATABASE MANAGEMENT SYSTEMS Previous Question Paper (April/May - 2023 - R15)
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
Distinguish between super key and Candidate key.
Answer
A super key is a set of one or more attributes that uniquely identifies a tuple in a relation. A candidate key is a minimal super key, meaning it contains no unnecessary attributes; every candidate key is a super key, but not every super key is a candidate key.
How do you represent the following in E-R model?
i) Week entity set ii) Role iii) Strong entity set
Answer
i) Weak entity set: Represented by a double-lined rectangle, connected to its identifying relationship by a double-lined diamond.
ii) Role: Represented by labeling the edges connecting an entity set to a relationship set to indicate the specific function the entity plays.
iii) Strong entity set: Represented by a single-lined rectangle.
What are various Domain constraints SQL?
Answer
Sign in to view the complete answer paper.
Explain tuple relational calculus.
Answer
Sign in to view the complete answer paper.
Define functional dependencies with example.
Answer
Sign in to view the complete answer paper.
What are the conditions for 2NF with example?
Answer
Sign in to view the complete answer paper.
Explain about durability of transaction.
Answer
Sign in to view the complete answer paper.
Explain about the multiple granularity.
Answer
Sign in to view the complete answer paper.
What is the order of B+ tree?
Answer
Sign in to view the complete answer paper.
What is difference between Indexing and hashing?
Answer
Sign in to view the complete answer paper.
Part B
What are the goals and advantages of DBMS?
Answer
Sign in to view the complete answer paper.
Develop an E-R Diagram for any Banking enterprise system.
Answer
Sign in to view the complete answer paper.
What are the functions of Database Administrator?
Answer
Sign in to view the complete answer paper.
What is data model? Explain Relational Model and E-R model.
Answer
Sign in to view the complete answer paper.
What are NULL values? Are they supported in relational model? How do they effect the meaning of queries? Can primary key fields of table contain null values?
Answer
Sign in to view the complete answer paper.
What is the difference between tuple relation calculus and domain relation calculus?
Answer
Sign in to view the complete answer paper.
What aggregate operators does SQL support ? Explain.
Answer
Sign in to view the complete answer paper.
Explain how to implement triggers in SQL.
Answer
Sign in to view the complete answer paper.
Explain about the Functional dependency and Multivalued dependency.
Answer
Sign in to view the complete answer paper.
What are the conditions required for a relation to be in 3NF and 4NF? Explain.
Answer
Sign in to view the complete answer paper.
Explain about the lossless join and dependency preserving with examples.
Answer
Sign in to view the complete answer paper.
Compute the closer of the following set of functional dependencies for a relation scheme. R(A,B,C,D,E,F,G,H), F={AB→C, A→DE, B→F, F→GH}. List out the candidate keys of R.
Answer
Sign in to view the complete answer paper.
Explain Multiple granularity locking approach and how does it works.
Answer
Sign in to view the complete answer paper.
What is log file? Explain the following log based recovery schemes: i) Deferred data base modification ii) immediate data base modification.
Answer
Sign in to view the complete answer paper.
Show that the two phase locking protocol ensure the conflict serializability and that transactions can be serialized according to their locks.
Answer
Sign in to view the complete answer paper.
Explain about remote backup systems.
Answer
Sign in to view the complete answer paper.
How does ISAM handles insert and delete operations? Explain.
Answer
Sign in to view the complete answer paper.
Discuss the relationship between Extendible and Linear Hashing. What are their relative merits and demerits?
Answer
Sign in to view the complete answer paper.
What is indexing? Explain the cluster index, primary and secondary indexes with examples.
Answer
Sign in to view the complete answer paper.
Differentiate between tree based and Hash based indexes.
Answer
Sign in to view the complete answer paper.