Distributed and Object Oriented Database - Unit Wise Questions

1. What is data fragmentation? Explain horizontal, vertical, and mixed fragmentation with suitable example.

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

2. Discuss query decomposition in distributed databases. How is it different from query localization?

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

3. Explain different characteristics of object oriented data model. What is extended relational model approach for object oriented database management system?

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

4. Define client/server architecture. What is distributed multidatabase system architecture?

5. Discuss different design issues that arise in building a distributed DBMS.

4. Differentiate between distributed database with centralized database.

6. Discuss semijoin operation. Compare it with join operation.

5. Discuss MDBS architecture.

7. Define transaction. Discuss architectural aspects of distributed transaction.

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

8. What are different types of failures in distributed database management systems? Explain.

7. Discuss normalization step of query decomposition.

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

9. Why do we need concurrency control? Discuss distributed two phase locking technique.

10. What is object definition language? How is it different from object query language?

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

11. What are the performance issues related with object oriented database management systems?

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

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

12. Discuss the performance issues of OODBMS.

12. What are the performance issues related with object oriented database management systems?

13. Write short notes on:

a) Autonomy

b) CORBA

13. Write short notes on:

a) Object identity

b) CORBA