221. ADVANCED RDBMS
Maximum : 100 Marks
SECTION - A ( 8 × 5 = 40)
Answer any EIGHT questions.
All questions carry equal marks.
1. Write about object database conceptual design.
2. With illustration, explain the nested relational model.
3. Give a note on Boyce-Codd normal form.
4. Briefly explain the join dependencies and fifth normal form.
5. State the importance of system catalogs for database management systems.
6. With examples, explain how do SQL queries can be translated into relational algebra.
7. Write about granularity of data items and multiple granularity level locking.
8. Discuss the concept of shadow paging.
9. Give a note on multimedia databases.
10. List out various applications of commercial deductive database systems.
SECTION - B (3 × 20 = 60)
Answer any THREE questions.
All questions carry equal marks.
11. Give a detailed description on informix universal server.
12. Explain the concept of database design and the implementation process.
13. Explain the following concepts :
(a) Any two basic algorithms for executing query operations in oracle. (12)
(b) Query optimization in oracle. (8)
14. (a) Describe the multiversion concurrency control techniques. (12)
(b) Write down the Aries recovery algorithm. (8)
15. Discuss the various concepts of deductive databases. (20)
RELATED LINKS
No comments:
Post a Comment