Distributed and Object Oriented Database - Unit Wise Questions

Unit 1: Introduction to Distributed Database,Distributed Database Architectures,Distributed Database Design
26 Questions

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

10 marks | Asked in 2075

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

10 marks | Asked in 2071

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

10 marks | Asked in 2075

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

10 marks | Asked in 2071

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

10 marks | Asked in 2075

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

10 marks | Asked in 2071

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

5 marks | Asked in 2075

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

5 marks | Asked in 2075

4. Differentiate between distributed database with centralized database.

5 marks | Asked in 2071

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

5 marks | Asked in 2075

5. Discuss MDBS architecture.

5 marks | Asked in 2071

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

5 marks | Asked in 2075

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

5 marks | Asked in 2071

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

5 marks | Asked in 2075

7. Discuss normalization step of query decomposition.

5 marks | Asked in 2071

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

5 marks | Asked in 2071

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

5 marks | Asked in 2075

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

5 marks | Asked in 2075

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

5 marks | Asked in 2071

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

5 marks | Asked in 2075

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

5 marks | Asked in 2071

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

5 marks | Asked in 2071

12. Discuss the performance issues of OODBMS.

5 marks | Asked in 2071

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

5 marks | Asked in 2075

13. Write short notes on:

a) Autonomy

b) CORBA

5 marks | Asked in 2071

13. Write short notes on:

a) Object identity

b) CORBA

5 marks | Asked in 2075

Unit 2: Distributed Query Processing,Distributed Transaction Management, Distributed Concurrency Control,Reliability of Distributed DBMS and Recovery
0 Questions
Unit 3: Object Oriented Database Concept, OODBMS Architecture Approach,The Object Oriented DBMS Architecture
0 Questions