DISTANCE EDUCATION
M.Sc. DEGREE EXAMINATION, DECEMBER 2017.
OBJECT ORIENTED DBMS
(2002 onwards)
Time Three hours Maximum 100 marks
PART A — (10 x 3 30 marks)
Answer ALL questions.
1. What are the levels of abstraction in a DBMS?
2. What are weak entities? Give an example.
3. What are the set operations supported by SQL?
4. What is the use of cursor?
5. What do you mean by functional dependency?
6. What is denormalization?
7. List out the objectives that should be consider while
designing a secure database application.
8. Mention the architectures proposed for building parallel
DBMS.
9. State the purpose of URL.
10. Write the differences between reference types and
structured types.
Sub. Code
15
DE-2783
2
SP 5
PART B — × 10 40 marks)
Answer any FOUR questions.
11. Compare file systems with DBMS.
12. Explain the conceptual database design with the E-R
model.
13. What is Trigger? Explain with an example.
14. Describe the Boyce-Codd normal form.
15. What is distributed database? Explain the properties and
its types.
16. Explain the ODMG data model.
PART C — x 15 30 marks)
Answer any TWO questions.
17. Explain the structure of a DBMS.
18. Describe the fourth and fifth normal with an example.
19. How various organisations can be implemented in
parallel? Discuss.