Advanced Database Management System Final Examination:Chandigarh University

📘 Chandigarh University – MCA/BCA/B.Tech

These Semester papers are part of the official examinations of Chandigarh University, designed to test knowledge and practical understanding of core MCA, Computer Applications, and B.Tech subjects.

💡 Each paper encourages students to think critically, apply concepts, and showcase problem-solving skills — helping them prepare for real-world IT challenges.

Usage Condition:

📖 Papers are for reference and study purposes only.
🧑‍🎓 Students should use them responsibly and not for any malpractice.
📅 Availability depends on the course and year.

Advanced Database Management System

Subject Code: 24CAT601 | Semester: 1
Time: 3 Hours | Max Marks: 60

Section A

(5 × 2 = 10 Marks)

State what SPJ-SPID stands for in the context of data and process distribution. (CO2)
Classify the differences between a relation schema and a relational instance. (CO1)
Explain the state transition diagrams which help in understanding complex systems and their behavior. (CO1)
Define ‘tunes-Isum based protocol’ in DBMS. (CO4)
Summarize recovery and atomicity in recovery techniques. (CO5)

Section B

(5 × 2 = 10 Marks)

Differentiate between Instance and Schema. (CO2)
Explain with the help of suitable examples. (CO2)
Demonstrate the importance of schema mapping in facilitating schema matching and integration. (CO3)
Interpret the strategies and techniques employed for managing deadlocks in database systems. (CO4)
Providing examples to elucidate each strategy. Explain the concept of a Recovery Algorithm in the context of database management systems. (CO3)

Section C

(3 × 10 = 30 Marks)

1. Differentiate between physical, logical and view level data abstraction. Also differentiate between logical and physical level. (CO2)
2. Develop an explanation of various operators used in Algebra with examples. (CO3)
1. Distinguish between active databases, temporal databases, spatial databases, and multimedia databases in terms of their data representation, storage, indexing methods, and query processing techniques. (CO4)