DMC 1971 Advanced Databases February 2014 Question Paper

Anna University MCA Distance Education Advanced Databases Question Paper / Anna University MCA Distance Education Previous Year Question Paper / DMC 1971 Advanced Databases Question Papers with Answers / DMC 1971 Advanced Databases February March Question Papers with Answers / February March DMC1971

Question Paper Code : 96324

M.C.A. DEGREE EXAMINATION, FEBRUARY/MARCH 2014

Elective

DMC 1971 – ADVANCED DATABASES

(Regulation 2009)

Time : Three Hours                                               Maximum : 100 Marks

Answer ALL Questions

PART A – (10 X 2 = 20 Marks)

1. What is referential key constraint?

2. State the purpose of query optimization.

3. Differentiate transient and persistent objects.

4. Justify the need for concurrency control.

5. What is client/server model?

6. Define: mobile database.

7. What is active rule?

8. Give advantages of distributed database systems.

9. When did you say that the consistency of a database is lost?

10. What is authentication? How does it differ from authorization?

PART B – (5 X 16 = 80 Marks)

11. (a) (i) Describe in detail about hashing techniques. (8)

(ii) Briefly explain about relational model concepts. (8)

Or

(b) Why normalization is required? Explain 1NF, 2NF, 3NF, and BCNF in detail with suitable examples. (16)

12. (a) How will you model and design an object oriented database? Explain in detail. (16)

Or

(b) Write short notes on the following;

(i) Database administration (8)

(ii) Recovery (8)

13. (a) What is enhanced data model? Explain each of them. (16)

Or

(b) Write a detailed note on web databases. (16)

14. (a) Write short notes on:

(i) Active databases. (8)

(ii) Deductive databases. (8)

Or

(b) (i) Explain any one of the concurrency control protocol in detail with example. (8)

(ii) Discuss in detail the parallel database. (8)

15. (a) Describe the database tuning techniques in detail. (16)

Or

(b) (i) Explain the integrity issues in database design. (8)

(ii) Discuss the research issues related to security in database design. (8).

________________