📘 About the Test
Subject: Advanced Database Management System (24CAT-601)
Program: MCA – Artificial Intelligence & Machine Learning
Semester: 1 | Time: 1 Hour | Marks: 20
Instructions: Attempt all questions.
📝 Section A (5 x 2 = 10 marks)
- 1. Define functional dependency in database management system. (CO1)
- 2. Explain the concept of schema mapping and its role in data interoperability between databases. (CO3)
- 3. Identify some challenges and considerations when working with complex integrity constraints in a database. (CO1)
- 4. Explain issues in multi-database query processing. (CO2)
- 5. Explain the concept of scheme refinement in database design. (CO1)
🧠 Section B (2 x 5 = 10 marks)
- 6. Demonstrate how views can be used in query rewriting to optimize or simplify SQL queries. (CO2)
- 7. Compare and contrast centralized versus decentralized approaches to data localization in distributed systems. (CO3)
🤝 If you like this, share and connect with us!
Spread the word, support our work, and follow us for more educational content.
