Distributed Database Management Systems Quiz

What is a Distributed Database?

• A centralized collection of data

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

• A single database stored at one site

• A database that cannot be accessed remotely

What is a key advantage of Distributed DBMSs?

• Increased complexity

• Improved shareability and local autonomy

• Higher costs

• Reduced availability

Which of the following is a disadvantage of Distributed DBMSs?

• Improved performance

• Increased reliability

• Complexity

• Better scalability

What type of DDBMS uses the same DBMS product at all sites?

• Heterogeneous DDBMS

• Homogeneous DDBMS

• Centralized DDBMS

• Distributed DDBMS

What is the purpose of fragmentation in a distributed database?

• To eliminate the need for replication

• To divide relations into sub-relations for distribution

• To improve data security

• To centralize data storage

Which of the following is NOT a type of fragmentation?

• Sequential

• Mixed

• Horizontal

• Vertical

What is a Remote Request in the context of transactions?

• A single SQL statement accessing multiple databases

• A sequence of SQL statements executed on a single remote database

• A single SQL statement accessing data at a remote database server

• A complex transaction involving multiple sites

What is the main function of a Distributed DBMS?

• To manage a centralized database

• To permit management of distributed databases and make distribution transparent

• To eliminate the need for local DBMSs

• To provide a single point of access for all data

Which architecture is NOT a main architecture for Parallel DBMSs?

• Shared disk

• Shared nothing

• Distributed memory

• Shared memory

What is the purpose of replication in a distributed database?

• To eliminate data redundancy

• To centralize data access

• To store data in a single location

• To maintain copies of fragments at several sites