B.Sc. (Three Year) DEGREE EXAMINATION, OCTOBER 2018.
End Semester Examination
Fifth Semester
Computer Science
(Regular/Supplementary)
Paper V DATABASE MANAGEMENT SYSTEM
2 C 53115
Time 3 Hours Max. Marks 70
PART — A
Answer any FIVE of the following questions. 4 20 Marks)
1. Define data, information and database.
2. What is data independence and why it taking in file systems?
3. What is physical independence?
4. Define entity clusters.
5. What is attribute inheritance?
6. What is sub query? Explain with suitable example.
7. What is package in PL/SQL?
8. What is exception handling in PL/SQL?
PART — B
Answer ALL the following questions. 10 50 Marks)
UNIT I
9. What are the components and interfaces of DBMS?
Or
Describe evolution of database management.
UNIT II
10. What are the constraints on specialization and generalization?
Or
What is relationship, and what three types of relationships exist?

UNIT III
11. What are the advantages of relational algebra?
Or
Discuss about relational data model.
UNIT IV
12. Give an examples for embedded SQL.
Or
What is Join? Explain its types.
UNIT V
13. Discuss about control structure in PL/SQL.
Or
What is the difference between procedure and function in PL/SQL?