Total No. of Questions 18] [Total No. of Pages 02
M.C.A. DEGREE EXAMINATION, MAY 2018
First Year
DATABASE MANAGEMENT SYSTEMS
Time 3 Hours Maximum Marks :70
SECTION A
Answer any three questions. x 15 45)
Q1) What is information system? Discuss components of information.
Q2) Explain about Sequential and Indexed file organizations with suitable example.
Q3) Discuss different classification of data models based on their physical storage.
Q4) Explain about information management description and data manipulation in
hierarchical database management systems.
Q5) Explain about database recovery mechanism.
SECTION B
Answer any five questions. x 4 20)
Q6) Describe the different associations between field.
Q7) Write about physical address pointer and relative address pointer.
Q8) Explain about multi list data structure with example.
Q9) Write about first and second normal forms with suitable example.
Q10) Explain about data volume and usage analysis.
Q11) Describe any four DML commands of IDMS.
Q12) Write about different relational algebra operations.
Q13) Give the responsibilities of DBA.
SECTION C
Answer all questions. × 1
Q14) Define field.
Q15)What is meant by metadata?
Q16)What is PC FOCUS?
Q17) What is E R model?
Q18) What is concurrency?