Distributed Database Management Systems Quiz

Which of the following are levels of data and process distribution in DDBMS?

• SPSD

• MPSD

• MPMD

• SPMP

Which characteristics apply to a distributed request?

• Can access data from multiple sites in a single SQL statement

• Provides fragmentation transparency

• Can only access data from one site at a time

• Is always slower than a centralized request

Transaction transparency ensures that distributed transactions are treated as centralized transactions.

• True

• False

In a remote transaction, each SQL statement can reference data from multiple remote sites.

• True

• False

What level of data and process distribution describes a system where all processing and data storage occur on a single computer?

• SPSD

• MPSD

• MPMD

• DPMS

In which type of distributed operation can a single SQL statement access data from multiple remote sites?

• Remote request

• Remote transaction

• Distributed transaction

• Distributed request

What is the primary purpose of transaction transparency in DDBMS?

• To increase processing speed

• To reduce network traffic

• To maintain data consistency and integrity

• To simplify database design

Which level of data and process distribution would be most appropriate for a multinational company with offices and data centers in multiple countries?

• SPSD

• MPSD

• MPMD

• None of the above

Answer explanation

For a multinational company with offices and data centers in multiple countries, the most appropriate level of data and process distribution would be MPMD, which stands for Multiple Processes and Multiple Data centers. This allows for efficient management and coordination across different locations.

What type of distributed operation is formed by several requests that access data at a single remote site?

• Remote request

• Remote transaction

• Distributed transaction

• Distributed request

Which of the following best describes the MPSD level of distribution?

• Multiple processes on one computer accessing a single database

• Multiple computers accessing a single data repository

• Multiple computers each with their own local database

• A single computer accessing multiple databases