As you want I am here providing you sample paper of the M.Sc IT Exam of 2nd year of the Annamalai University.

Sample paper :
Advance RDBMS paper of M.Sc IT Exam of 2nd year of the Annamalai University
SECTION - A
Answer any EIGHT questions.
ALL questions carry EQUAL marks.
1. Discuss the complex objects.
2. Explain the informix unversal server.
3. Explain the features of Boyce-Codd normal
form.
4. Discuss the database design process.
5. Define query optimization and explain its
significance for a DBMS.
6. What is a query execution plan?
7. Explain the validation control techniques.
8. Discuss the issues in database recovery.
9. Explain any five Oracle futures.
10. Discuss the interpretation of rules.
SECTION - B
11. Differentiate the following with respect to the
object oriented data model :
(a) Objects and Attributes.
(b) Methods and Messages.
(c) Overriding and Overloading.
(d) Polymorphism and Dynamic Binding.
12. Compare First, Second and Third normal forms
with examples.
13. Explain the desirable properties of
transactions.
14. Write notes on :
(a) Multiversion concurrency control
techniques.
(b) Validation concurrency control
techniques.
15. List the advantages and disadvantages of
DDBMS and explain it.



Address:
Annamalai University
Annamalai Nagar, Chidambaram, Tamil Nadu 608002 ‎
04144 238 282 ‎ •

Map: