B.Sc. (Three Year) DEGREE EXAMINATION, OCTOBER/NOVEMBER 2017.
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. What are the drawbacks of file system?
2. Define data and information. Explain with example.
3. What are the different types of relationship?
4. What is the difference between table and database?
5. Give an examples of relational set operators.
6. What are data types in SQL?
7. What is Exception handling?
8. Write steps to create a PL/SQL programe to print 1 to 100 numbers.
PART — B
Answer ALL the following questions. 10 50 Marks)
9. What are the objectives of DBMS?
Or
What are the main components of a database system?
10. What are the advantages of ER-modeling?
Or
Write about specialization and generalization.
11. Explain CODD rules. Explain each rule.
Or
What are the advantages and limitations of relational alzebra?

12. Write an examples for DDL and DCL commands.
Or
What is embedded SQL and how it is used?
13. What is trigger and what is its purpose?
Or
Write a syntax and examples for control structures in PL/SQL.
———————