DISTANCE EDUCATION
M.Sc. DEGREE EXAMINATION, MAY 2018.
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 advantages of DBMS?
2. List any two queries in DBMS.
3. What is meant by Aggregation?
4. Write about ER model.
5. Define Trigger.
6. Define Null Values.
7. What are the kinds of Dependencies?
8. Write about Database Security.
9. What is meant by Discretionary Access Control?
10. Write about WWW.
PART B — × 10 40 marks)
Answer any FOUR questions.
11. What is Relational Model? Explain.
12. Explain conceptual database design with the ER model.
Sub. Code
15
DE-3883
2
wk11
13. Explain about queries over multiple relations.
14. Explain about Clustering and Indexing.
15. Describe the Architecture for parallel databases.
16. Explain about the Database design for an ORDBMS.
PART C — × 15 30 marks)
Answer any TWO questions.
17. With suitable example explain about the Multivalued
Dependencies.
18. What is ODBC and JDBC? Explain the need of ODBC
and JDBC.
19. Explain about the Distributed Query Processing.