B.Com. (Three Year) DEGREE EXAMINATION, OCTOBER 2018
End Semester Examination
Fifth Semester
(Regular/Supplementary)
Paper V (Core) DATABASE MANAGEMENT SYSTEM
2 C 53035
Time 3 Hours Max. Marks 70
SECTION — A
Answer any FIVE of the following questions. 4 20 Marks)
1. Discuss about historical roots of database.
2. What are the steps involved in DBLC?
3. What is the difference between data and information?
4. Explain classification of attributes.
5. Write any five CODD rules.
6. How to modify the contents of table?
7. What are the parts of PL/SQL structure?
8. Define PL/SQL package.
SECTION — B
Answer ALL of the following questions. 10 50 Marks)
UNIT I
9. What are the objectives of DBMS?
Or
Explain in detail the database system environment.
UNIT II
10. What are the advantages of DBMS?
Or
Explain in brief about the degree of data abstraction.

UNIT III
11. What is an entity relationship model?
Or
What is generalization and specialization? Explain with suitable examples.
UNIT IV
12. Explain the types of integrity constraints.
Or
What are set-operators?
UNIT V
13. Explain about procedural SQL.
Or
What are iterative controls? Explain with examples.