JAWAHARLAL NEHRU TECHNOLOGICAL UNIVERSITY HYDERABAD
JAWAHARLAL NEHRU TECHNOLOGICAL UNIVERSITY HYDERABAD B.Tech III DATABASE MANAGEMENT SYSTEMS Previous Question Paper (January/February - 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 logical data independence and physical data independence.
Give example for referential integrity.
Answer
Referential integrity ensures that a foreign key value in one table must match a primary key value in the referenced table. For example, in a database with a Students table and an Enrollments table, the StudentID in the Enrollments table must exist in the Students table.
What is an unsafe query?
Answer
Sign in to view the complete answer paper.
What is a correlated query?
Answer
Sign in to view the complete answer paper.
Define functional dependency.
Answer
Sign in to view the complete answer paper.
Quote an example for transitive dependency.
Answer
Sign in to view the complete answer paper.
List the desirable properties of database transaction.
Answer
Sign in to view the complete answer paper.
What is the importance of multi version scheme?
Answer
Sign in to view the complete answer paper.
Which file organization is preferred for insert operation and Why?
Answer
Sign in to view the complete answer paper.
What are the benefits of indexing?
Answer
Sign in to view the complete answer paper.
Part B
Discuss the functionalities of database administrator.
Answer
Sign in to view the complete answer paper.
"DBMS provides data abstraction." Substantiate this statement.
Answer
Sign in to view the complete answer paper.
Construct an ER diagram for designing database for a multi-specialty hospital. Incorporate basic and additional features of ER model in your diagram.
Answer
Sign in to view the complete answer paper.
Consider the following database schema to write queries in Relational Algebra: Student( sid, sname, total_credits), Course( cno, cname, credits), Enroll(sid, cno, grade)
Find the names of the students enrolled for course 'DBMS'
Answer
Sign in to view the complete answer paper.
Find the names of the courses enrolled and grades obtained by 'Mohan'
Answer
Sign in to view the complete answer paper.
Find the students who secured more than 100 credits
Answer
Sign in to view the complete answer paper.
Find the courses with only one credit.
Answer
Sign in to view the complete answer paper.
With example queries, explain aggregate functions of SQL.
Answer
Sign in to view the complete answer paper.
Compare group by and having clauses of SQL.
Answer
Sign in to view the complete answer paper.
Does first normal form induce redundancy into relational schema? Justify your answer.
Answer
Sign in to view the complete answer paper.
Explain the Armstrong’s axioms used in functional dependency closure computation.
Answer
Sign in to view the complete answer paper.
With an example, explain the concept of join dependencies.
Answer
Sign in to view the complete answer paper.
Substantiate the need of schema refinement in database design.
Answer
Sign in to view the complete answer paper.
Make a detailed comparison of lock based protocol and time-stamp based protocol for concurrency control.
Answer
Sign in to view the complete answer paper.
Explain remote backup system for recovery.
Answer
Sign in to view the complete answer paper.
Discuss the use of pin-count and dirty bit variables in buffer management.
Answer
Sign in to view the complete answer paper.
'Multilevel indexing improves system performance and minimizes response time.' Substantiate this statement with necessary examples.
Answer
Sign in to view the complete answer paper.
Contrast heap file organization with hash file organization.
Answer
Sign in to view the complete answer paper.
Is linear hashing a dynamic indexing? Justify your answer.
Answer
Sign in to view the complete answer paper.