๐ 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.
