Course Title: Advanced Database Management System
Course Code: PEC-CSE-310-G
Semester: B.Tech. 6th Semester (CSE)
May—2023 Examination
Short Answer Questions (6 × 2.5 = 15 marks)
- (a) Natural join
(b) Log based recovery
(c) 3NF
(d) Query optimization
(e) Cartesian product
(f) Distributed database
UNIT - I (15 marks)
- (a) Define normal forms. [8]
(b) Define Relational Algebra. [7] - Explain in detail about query processing. [15]
UNIT - II (15 marks)
- Why is recovery needed in database? Discuss checkpoint-based recovery. [15]
- What is concurrency control? Discuss locking, timestamp and multiversion concurrency control. [15]
UNIT - III (15 marks)
- (a) What do you mean by object-oriented database? [8]
(b) Discuss the difference between relational and object-oriented databases. [7] - Discuss various replication techniques of DDBMS by giving their merits and demerits. [15]
UNIT - IV (15 marks)
- Explain features of enhanced SQL on Object relational database with help of example. [15]
- Discuss components of data warehouse in details. [15]
July—2021 Examination
Short Answer Questions (15 marks)
- Write short notes on the following: [6 × 2.5 = 15]
(a) Second Normal Form (2NF)
(b) Relational Algebra
(c) Deadlock in distributed database
(d) Query processor
(e) Replication
UNIT - I (15 marks)
- Explain relational model and network model in detail. [15]
- Write and elaborate the various steps involved in query processing. [15]
UNIT - II (15 marks)
- (a) What is Log based recovery? Explain immediate database modification. [7.5]
(b) Explain different states of a transaction and also draw transaction state diagram. [7.5] - (a) Explain optimistic protocol. [7.5]
(b) Describe 2-phase locking protocol in detail. [7.5]
UNIT - III (15 marks)
- Explain the various fragmentation techniques in distributed databases with the help of suitable example. [15]
- Write and discuss two-phase and three-phase commit protocol. [15]
UNIT - IV (15 marks)
- Explain object oriented and object relational databases. Also give the difference between these. [15]
- (a) Explain object, object identity, equality and object reference. [7.5]
(b) Write the concept of aggregation and association in Object oriented databases. [7.5]