Anna University Chennai 2006 M.C.A Computer Aplications DATABASE MANAGEMENT SYSTEM -MC 1654 - Question Paper

M.C.A. DEGREE exam
NOV/DEC 2006
2nd SEMESTER
DATABASE MANAGEMENT SYSTEM
(REGULATION 2005)

ans ALL ques.
PART- A (10x2= 20 marks)

1. How Is the database management system indispensable I data handling?
2. What is semantic data model?
3. elaborate integrity constraints in relational model?
4. What is the use of embedded Sql?
5. describe hash based indexing in data storage operations.
6. elaborate composite search keys? discuss with a example.
7. what do you meant by query optimization?
8. what does a query eevaluation plan consists of?
9. state the purpose of locking protocol indbms operations.
10. elaborate the 2 important functions of recvery management?

PART B (5x16=80 marks)

11.a.i. Narrate the advantage of dbms systems.
or
11.a.ii. explain the steps involved in the design of database systems.
11.b.i. Illustrate the concept of relationships and relationship sets in entity relationship (ER) diagrams, witha suitable examples.
11.b.ii. what are o the key constraint construct in ER models, with an example.
12.a.i. What is the use of cursors in embedded SQL? Specif the basic cursor definition format, giving illustrative examples?
12.a.ii. provide an example of foreign key constraintsin relational models and develo a SQL statement for the identical.
12.b. How are the relational models designed based on the ER models? explain with respect to the problems of tables, relationship without constraints and key constraints?
13.(a) discuss the mechanism of hash based indexing with an example.
13.(b) define the different levels of redundancy in RAID systems in detail.
14.(a) discuss the working of query optimizer with ablock diagram.
14.(b) explain the problems in implementing optimization strateges for the JOIN s queries.
15.(a) What is the role of COMMIT, ROLLBACK and SAVEPOINT the SQL statements in transaction management?
15.(b) Write short notes on buffer management.

Earning:   Approval pending.