2005 Madras University M Sc Computer Science database management systems Question paper for exam preparation. Question paper for 2005 Madras University M Sc Computer Science database management systems Question paper, 2005 Madras University M Sc Computer Science database management systems Question paper. SiteMap
K2Questions Logo

2005 Madras University M Sc Computer Science database management systems Question paper

University Question Papers
2005 Madras University M Sc Computer Science database management systems Question paper
PART A- (5 x 2 = 10 marks)

Answer ALL questions.

All questions carry equal marks. Each answer should not exceed 50 words.



1.Show the basic structure of an SQL expression.

2.Define assertion.

3.Write an advantage of object-relational databases.

4.Distinguish between indexing and hashing technique

5.Define replication.



PART B - (4 x 5 = 20 marks)



Answer any FOUR questions.

All questions carry equal marks.

Each answer should not exceed 250 words.



6. lllustrate the domain relational calculus with an example.

7. Explain the various authorization operations in SQL.

8. Explain how inheritance used in object-relational database.

9. Explain about two-phase locking and its implementation

10. What are the different forms of schedule equivalence in serializability? Explain.

11. Compare between centralized and client server systems.



PART C - (5 x 10 = 50 marks)

Answer ALL questions.

All questions carry equal marks. Each answer should not exceed 500 words.



12.(a) Explain the structure of relational database.

Or

(b) Explain the following operations in relational algebra.

(i) Union operation

(ii) Set operation.

(iii) Division operation.



13. (a) Explain the normalization technique in relational database.

Or

(b) Explain domain constraints and referential integrity.









14. (a) Illustrate the file organization methods with an example.

Or

(b) Explain the functions and procedures in SQL



15. (a) Explain about static hashing technique with an example.

Or

(b) Briefly explain about join operations in query

processing.



16. (a) Explain parallel architecture system database architecture with neat diagram.

Or



(b) Explain about-distributed data storage.


About us | SiteMap | Terms of use | Privacy Policy | Disclaimer | Contact us | ©2010 K2Questions.com

2005 Madras University M Sc Computer Science database management systems Question paper for exam preparation. Question paper for 2005 Madras University M Sc Computer Science database management systems Question paper, 2005 Madras University M Sc Computer Science database management systems Question paper