Calicut University 2006 M.C.A , - Database Management System - Question Paper
Third semester M.C.A Degree Examination, June 2006
Database Management System - MCA2K303
M06303
THIRD SEMESTER MCA DEGREE EXAMINATION. JUNE 2006 DATABASE MANAGEMENT SYSTEM -MCA2K303
Time-3 hours Maximum Marks-100
Answer any five questions. All carry EQUAl. marks.
la. Explain about the advantages of a DBMS over a {lie processing system, b. Explain about ER mode) in detail.
2a. Explain about EER model in detail, b. Write a note on database language? and interfaces-
3a. Explain about various secondary storage dcvices in detail, b. Explain about B-Trees in detail.
4a. Explain about various functional dependences in detail, b. Explain about 3NF.BCNF and NF in detail.
5a. Explain about additional relational algebra operations in detail, b. Explain about various operations in SQL
6a. Explain about the desirable properties of transactions with examples, b. Explain about various lock-based protocols for concurrency control.
7. Explain about various database recovery techniques in detail.
Attachment: |
Earning: Approval pending. |