Wednesday, February 17, 2016

Anna University MCA MC 1654 – DATABASE MANAGEMENT SYSTEMS Question November December 2006

MC 1654 – Database Management Systems - November December 2006 Question Paper / Anna University MCA Exam November December 2006 Question Paper / MC1654 DBMS November December 2006 Question Paper / MC1654 Database Management Systems Previous Year MCA Question Paper / Anna University Affiliated Colleges MCA Question Papers / MC1654 DBMS Regulation 2005 MCA Question Paper / MCA Second Semester Question Paper

Question Paper Code :
(Regulation 2005)
Time : Three Hours                                                         Maximum : 100 marks
Answer ALL Questions
PART A – (10 X 2 = 20 marks)

1. How is the database management system indispensable in data handling?
2. What is semantic data model?
3. What are integrity constraints in relational model?
4. What is the use of Embedded SQL?
5. Define hash based indexing in data storage operations.
6. What are composite search keys? Explain with a example.
7. What do you meant by query optimization?
8. What does a query evaluation plan consists of?
9. State the purpose of locking protocols in DBMS.
10. What are the two important functions of Recovery Management?

PART B – (5 X 16 = 80 marks)

11. (a) (i) Narrate the advantage of DBMS systems.
(ii) Discuss the steps involved in the design of database systems.
(b) (i) Illustrate the concept of relationships and relationship sets in Entity Relationship (ER) model with a suitable example.
(ii) Elaborate on the key constraint construct in ER models with an example.
12. (a) (i) What is the use of cursors in embedded SQL? Specify the basic cursor definition format, giving illustrative examples.
(ii) Give an example of foreign key constraints in relational models and develop an SQL statement for the same.
(b) How is the Relational Model designed based on the ER models? Discuss with respect to the issues of tables, relationship without constraints and key constraints?
13. (a) Explain the mechanism of hash based indexing with an example.
(b) Describe the various levels of RAID systems in detail.
14. (a) Explain the working of Query Optimizer with a block diagram.
(b) Discuss the issues in implementing optimization strategies for the JOIN queries.
15. (a) What is the role of COMMIT, ROLLBACK and SAVEPOINT SQL statements in transaction management?
15. (b) Write short notes on Buffer Management.


Featured Content

Multiple choice questions in Natural Language Processing Home

MCQ in Natural Language Processing, Quiz questions with answers in NLP, Top interview questions in NLP with answers Multiple Choice Que...

All time most popular contents

data recovery