๐ Mid Semester Test-1
Academic Year: 2024 โ 2025
Program: MCA โ Artificial Intelligence & Machine Learning
Subject Code: 24CAT-601 ย | ย Subject: Advanced Database Management System
Semester: 1 ย | ย Time: 1 Hour ย | ย Marks: 20
Instructions: Attempt all questions.
๐ Section A (5 ร 2 = 10 marks)
- Classify and compare MPMD with alternative parallel processing models in distributed databases. (CO1)
- Define deadlock in transaction management and describe one method to prevent it. (CO2)
- Illustrate the difference between strong and weak entity sets with examples. (CO2)
- Explain the purpose of query optimization in DBMS. (CO3)
- List advantages of database normalization with an example. (CO3)
๐ง Section B (2 ร 5 = 10 marks)
- Discuss concurrency control techniques in DBMS with suitable examples. (CO3)
- Evaluate the role of distributed databases in large-scale applications, highlighting benefits and challenges. (CO4)
โ Usage Conditions
- ๐ 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.
