Exam Details
| Subject | database management systems | |
| Paper | ||
| Exam / Course | pg diploma in computer applications (pgdca) | |
| Department | ||
| Organization | acharya nagarjuna university-distance education | |
| Position | ||
| Exam Date | May, 2017 | |
| City, State | new delhi, new delhi |
Question Paper
Total No. of Questions 10] [Total No. of Pages 01
P.G. DIPLOMA DEGREE EXAMINATION, MAY 2017
COMPUTER APPLICATIONS
Database Management Systems
Time 3 Hours Maximum Marks 70
Answer any Five questions
All questions carry equal marks
Q1) What is information system? Discuss components of information system and classify
different information systems.
Q2) Write in detail about sequential, indexed sequential and random file organizations.
Q3) Discuss different location methods and types of pointers of the data.
Q4) What is data model? Briefly explain different data models with neat sketch.
Q5) What is need of normalization? Explain the normalization of invoice and REORDER
report.
Q6) Describe the guidelines for mapping conceptual data model into relational data model
and network data model.
Q7) Discuss DML and DDL command of integrated database management systems.
Q8) Explain about relational algebra operations with example.
Q9) Write about resource locking and deadlock embrace in concurrency control.
Q10) What is meant by database recovery? Explain about forward land backward recovery.
P.G. DIPLOMA DEGREE EXAMINATION, MAY 2017
COMPUTER APPLICATIONS
Database Management Systems
Time 3 Hours Maximum Marks 70
Answer any Five questions
All questions carry equal marks
Q1) What is information system? Discuss components of information system and classify
different information systems.
Q2) Write in detail about sequential, indexed sequential and random file organizations.
Q3) Discuss different location methods and types of pointers of the data.
Q4) What is data model? Briefly explain different data models with neat sketch.
Q5) What is need of normalization? Explain the normalization of invoice and REORDER
report.
Q6) Describe the guidelines for mapping conceptual data model into relational data model
and network data model.
Q7) Discuss DML and DDL command of integrated database management systems.
Q8) Explain about relational algebra operations with example.
Q9) Write about resource locking and deadlock embrace in concurrency control.
Q10) What is meant by database recovery? Explain about forward land backward recovery.