M.sc. Computer Science Annamalai University DDE question papers

Originally Posted by Unregistered

M.Sc.DEGREE EXAMINATION (COMPUTER SCIENCE) ( SECOND SEMESTER ) ( PAPER - IX)
221 ADVANCED RDBMS

SECTION - A ( 8× 5=40)

1. Explain in detail overview of object model / ODMG.

2. Explain overview SQL-3 in detail.

3. Write short notes on normal forms.

4. Write short notes on database design process.

5. Write short notes on transaction processing.

6. Explain about locking techniques.

7. Discuss about time- stamp ordering.

8. Explain about database security.

9. Explain about distributed database.

10. Discuss about datalog notation.
SECTION - B ( 3×20 = 60)

Answer any THREE questions.
All questions carry equal marks.

11. Discuss the relational and extended relational database systems.

12. Write notes on :
(a) Third normal forms.
(b) Boyce Code normal form.

13. Explain the selectivity and cost estimates in query optimization.

14. Describe the concurrency control based on time stamp ordering.

15. Write notes on :
(a) Deductive database systems.
(b) Deductive object oriented databases.