JNTU
JNTU B.Tech II DATABASE MANAGEMENT SYSTEMS Previous Question Paper (February - 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 logical data independence.
Answer
Logical data independence is the ability to change the conceptual schema (the logical structure of the database) without requiring changes to the external schemas or the application programs that access the data.
What is a view?
Answer
A view is a virtual table that does not store data itself but is derived from the result of a stored query on one or more base tables. It provides a customized presentation of data, enhances security by restricting access to specific columns or rows, and simplifies complex queries for users.
What is procedural DML?
Answer
Sign in to view the complete answer paper.
What is an active database?
Answer
Sign in to view the complete answer paper.
What are spurious tuples?
Answer
Sign in to view the complete answer paper.
What is transitive rule for functional dependency?
Answer
Sign in to view the complete answer paper.
Define serializable schedule.
Answer
Sign in to view the complete answer paper.
What is the motivation for concurrent transactions?
Answer
Sign in to view the complete answer paper.
What is the use of cylinder on a disk?
Answer
Sign in to view the complete answer paper.
List the drawbacks of ISAM indexing technique.
Answer
Sign in to view the complete answer paper.
Part B
Explain the role of ER model in database design process with suitable examples.
Answer
Sign in to view the complete answer paper.
What is an integrity constraint? Explain enforcement of various integrity constraints in DBMS.
Answer
Sign in to view the complete answer paper.
With suitable example expressions, illustrate various operators available in Relational Algebra.
Answer
Sign in to view the complete answer paper.
Consider the following database schema to write queries in SQL. Student(Rollno, name, totalCredits), Course(Cno, cname, credits), Enroll(Rollno, Cno, Grade)
Find students who scored grade A in DBMS
Answer
Sign in to view the complete answer paper.
Find the students enrolled for DBMS and CO
Answer
Sign in to view the complete answer paper.
Find the courses having enrollment less than 50.
Answer
Sign in to view the complete answer paper.
What is redundancy? Explain the problems caused by redundancy.
Answer
Sign in to view the complete answer paper.
Does third normal form ensure dependency preservation? Justify your answer with suitable examples.
Answer
Sign in to view the complete answer paper.
Explain how time stamp based protocol ensures serializability of schedules.
Answer
Sign in to view the complete answer paper.
Demonstrate buffer management to support recovery techniques.
Answer
Sign in to view the complete answer paper.
Describe the significance of multi level indexing and its influence on tree based indexing.
Answer
Sign in to view the complete answer paper.
Make a comparison of extendible hashing and linear hashing techniques as indexing structures.
Answer
Sign in to view the complete answer paper.