ADVANCED RDBMS

Books For Preparation M.Sc. DEGREE EXAMINATION, 2010 ( COMPUTER SCIENCE ) ( SECOND SEMESTER )
( PAPER - IX )
221 . ADVANCED RDBMS
( New Regulations )
May ] [ Time : 3 Hours
Maximum : 100 Marks

PART - A (8 × 5 = 40)
Answers any EIGHT questions.
All questions carry equal marks.

1. Discuss briefly Object Query Language.
2. Write a note on the relational data model.
3. What is the need for functional
dependencies ? Explain.
4. Explain the role of information systems of
organizations.
5. Why are multivalued dependencies required ?
Discuss.
6. Bring out the effect of heuristics in query
optimization.
7. Discuss the transaction support in SQL.
8. What is the importance of granularity of data
items ?
9. Write a short note on deductive databases.
10. Explain the applications of commercial
deductive database systems.

PART - B ( 3 × 20 = 60)
Answer any THREE questions.
All questions carry equal marks.

11. Explain with two examples how C++ handles
binding.
12. Explain the various normal forms.
13. With a neat diagram, discuss in detail the
system architecture for DBMS.
14. Discuss in detail all the Concurrency Control
Techniques.
15. Explain the Client - Server Architecture and
its relationship to distributed databases.