DISTANCE EDUCATION
M.Sc.(Information Technology) DEGREE EXAMINATION,
MAY 2017.
OBJECT ORIENTED DBMS
(2002 Onwards)
Time Three hours Maximum 100 marks
SECTION A — (10 3 30 marks)
Answer ALL questions.
1. What is data model?
2. What are attributes? Give examples.
3. Define
Primary key
Foreign key.
4. Give the syntax of SELECT query.
5. Write the uses of conditions boxes.
6. What are the problems caused by redundancy?
7. What is the need for database tuning?
8. What is the role of DBA in security?
9. Why we need distributed data bases?
10. What is object-oriented database system?
Sub. Code
15
DE-480
2
wk16
SECTION B — × 10 40 marks)
Answer any FOUR questions.
11. Describe the different levels of Abstraction in a DBMS.
12. What is E-R model? What are the symbols used in E R
model? Explain with an example.
13. What is cursor? Explain the properties of cursor and its
usage.
14. With suitable example, explain third normal form.
15. Explain the discretionary access control approach with an
example.
16. How can you specify XML DTD? Explain.
SECTION C — 15 30 marks)
Answer any two questions.
17. Compare RDBMS with ODDBMS and ORDBMS.
18. Explain the architectures of distributed DBMS.
19. Illustrate the choices involved in tuning the conceptual
schema and explain.