Distributed and Object Oriented Database 2071

Tribhuwan University
Institute of Science and Technology
2071
Bachelor Level / Eighth Semester / Science
Computer Science and Information Technology ( CSC-457 )
( Distributed and Object Oriented Database )
Full Marks: 60
Pass Marks: 24
Time: 3 hours
Candidates are required to give their answers in their own words as far as practicable.
The figures in the margin indicate full marks.

Group A

Attempt any two questions. (2 x 10 = 20)

1. Discuss client/server architecture and peer-to-peer architecture of distributed DBMS.

10 marks view

2. What is reliability protocol? Discuss two phase commit protocol for distributed environment.

10 marks view

3. What is object-oriented database? Differentiate it with relational database . Discuss the characteristics of object oriented data model.

10 marks view

Group B

Attempt any Eight questions.(8 x 5 = 40)

4. Differentiate between distributed database with centralized database.

5 marks view

5. Discuss MDBS architecture.

5 marks view

6. What are the correctness rules of fragmentation? Discuss.

5 marks view

7. Discuss normalization step of query decomposition.

5 marks view

8. Discuss three situations that can occur if proper isolation is not maintained.

5 marks view

9. What is deadlock? Discuss deadlock prevention in distributed concurrency control.

5 marks view

10. Explain mean time between failures and mean time to repair.

5 marks view

11. What is object query language? Differentiate it with structured query language.

5 marks view

12. Discuss the performance issues of OODBMS.

5 marks view

13. Write short notes on:

a) Autonomy

b) CORBA

5 marks view