Scribd
Upload
5 views2 pages

Advanced RDBMS Exam Questions 2012

This document is an examination paper for the M.Sc. degree in Information Technology, specifically for the Advanced RDBMS course. It includes two sections: Section A with eight questions worth 5 marks each and Section B with three questions worth 20 marks each. Topics covered include complex objects, query optimization, database design, and normalization forms.

Uploaded by

Green Zone
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
5 views2 pages

Advanced RDBMS Exam Questions 2012

This document is an examination paper for the M.Sc. degree in Information Technology, specifically for the Advanced RDBMS course. It includes two sections: Section A with eight questions worth 5 marks each and Section B with three questions worth 20 marks each. Topics covered include complex objects, query optimization, database design, and normalization forms.

Uploaded by

Green Zone
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

Register Number :

Name of the Candidate :

6237
[Link]. DEGREE EXAMINATION, 2012
( INFORMATION TECHNOLOGY )

( THIRD SEMESTER )

( PAPER - XIII )

311. ADVANCED RDBMS

December ] [ Time : 3 Hours

Maximum : 100 Marks

SECTION - A (8 × 5 = 40)

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.

Turn Over
2 3

5. Define query optimization and explain its 13. E x p l a i n t h e desirable properties of


significance for a DBMS. transactions.

6. What is a query execution plan? 14. Write notes on :

7. Explain the validation control techniques. (a) Multiversion concurrency control


techniques.
8. Discuss the issues in database recovery.
(b) Va l i d a t i o n c o n c u r r e n c y c o n t r o l
9. Explain any five Oracle futures.
techniques.
10. Discuss the interpretation of rules.
15. List the advantages and disadvantages of
DDBMS and explain it.
SECTION - B (3 × 20 = 60)

Answer any THREE questions.


ALL questions carry EQUAL marks.

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.

You might also like