Alagappa University 2007 M.Sc Computer Science OBJECT ORIENTED DBMS - Question Paper

PART A — (10 ? three = 30 marks)
ans for ALL ques..
1. State and discuss data redundancy.
2. What do you mean meta data?
3. Define candidate key.
4. What is meant by E-R diagram?
5. List the 5 built-in aggregate functions.
6. Define view.
7. What is Cache coherency?
8. Abbreviate XSLT.
9. State DAG and discuss.
10. What do you mean persistence by reachability?
PART B — (4 ? 10 = 40 marks)
ans any 4 ques..
11. Write about the data abstraction and schema concepts in DBMS.
12. Explain mapping cardinality of data.
13. Describe the levels of union, intersect and other than nested queries.
14. Explain about clustering and indexing in database design.
15. Narrate about parallel query optimization.
16. Write about similarities of OODBMS and ORDBMS.
PART C — (2 ? 15 = 30 marks)
ans any 2 ques..
17. Narrate about designing active database query by example.
18. Write about 4th and 5th normal form.
19. Discuss in detail about parallel and distributed database.

Earning:   Approval pending.