Distributed Database, OODBMS, ORDBMS

What is a Distributed Database?

• A centralized database stored in a single location

• A collection of unrelated data from different computers

• A logically interrelated collection of shared data physically distributed over a network

• A database stored in a single server but accessed remotely

What is the main role of a Distributed DBMS?

• It stores backup copies of databases

• It handles complex queries across one site

• It manages distributed databases and makes them transparent to users

• It secures the network from external attacks

Which of the following best describes Distributed Processing?

• A database where fragments are stored in different sites

• Centralized data accessed over a network

• Each site has full control over its own data

• A backup system for remote servers

One key difference between Distributed DB and Distributed Processing is:

• Distributed DB stores only backup data

• Distributed Processing uses object-oriented tables

• Distributed DB has data split across locations; Processing keeps data centralized

• There is no difference

Which of the following is an advantage of Distributed DBMS?

• Centralized performance

• Increased complexity

• Modular growth

• High maintenance cost

Which is a disadvantage of using DDBMS?

• Better availability

• Easier design

• Security challenges

• Simple to implement

What does an Object-Oriented DBMS (OODBMS) store?

• Only relational tables

• Only text and numbers

• Objects including data and behavior (methods)

• Tables with primary keys only

Which concept is unique to OODBMS but not in relational DB?

• Class and Object

• Attributes

• Primary Key

• Tuples

Which of the following is a third-generation DBMS?

• Hierarchical Model

• Network Model

• Relational DBMS

• Object-Oriented DBMS

What was a problem with the first-generation DBMS?

• Too much normalization

• No SQL support

• Complex programs for simple queries and low data independence

• Required distributed fragments