B.Com. (Three Year) DEGREE EXAMINATION, OCTOBER/NOVEMBER 2017.
End Semester Examination
Fifth Semester
(Regular/Supplementary)
Paper V (CORE) DATABASE MANAGEMENT SYSTEMS
2 C 53035
Time 3 Hours Max. Marks 70
PART — A
Answer any FIVE of the following questions. 4 20 Marks)
1. What are the advantages of DBMS?
2. What is data independence?
3. What is datamodel in database?
4. Explain different types of attributes.
5. Explain Superkey and candidate key with examples.
6. Write about SQL history.
7. What are set operators? Explain with examples.
8. What is Cursor? Explain implicit cursor.
PART — B
Answer ALL the following questions. 10 50 Marks)
UNIT I
9. What are the objectives of DBMS?
Or
Explain classification of database management system.
UNIT II
10. Differentiate between file system and database system.
Or
What are the components of database system?

UNIT III
11. Explain Entity-Relationship model.
Or
What is relationship? Explain different types of relationships in ER-model.
UNIT IV
12. What are DML commands? Explain with examples.
Or
Explain about selection and projection operations.
UNIT
13. Write a syntax and example for any two control structure.
Or
What are different types of triggers? Explain each one.
———————