Total No. of Questions 10] [Total No. of Pages 02
P.G. DIPLOMA DEGREE EXAMINATION, MAY 2018
COMPUTER APPLICATIONS
Database Management Systems
Time 3 Hours Maximum Marks 70
Answer any FIVE questions x 14 70)
All questions carry equal marks
Q1) What is information systems? Explain the components of information system with neat
architecture.
Describe the advantages of database systems.
Q2) Explain about various approaches to organizing the files.
Q3) What is pointer? Write about different types of pointers.
Write about various locations methods with example.
Q4) Explain about network data model and relational data models with suitable examples.
Q5) Write about different steps to follow database design.
Q6) Illustrate database action diagram with suitable example.
Q7) What is PC-FOCUS? Explain about PC-FOCUS manipulation and PC-FOCUS
description?
Q8) Discuss various commands of data description language.
Q9) What is SQL? Discuss various SQL DML commands with syntax.
Q10) Explain about different security mechanism in database.