In a distributed DBMS:
A) A query or a transaction is able to access/process data stored at several sites
B) A query may only access one local database
C) A transaction may only update one local database
D) A query or transaction may only be issued at the site of the local database it will access

Question

Quizplus · Accepted Answer

In a distributed DBMS, a query or transaction has the capability to access/process data stored at several sites. This is one of the key features of a distributed database system where data is distributed across multiple locations. The system is designed to handle data that is geographically dispersed and provide access to multiple users at different locations. Data fragmentation, replication and distribution are some of the techniques used to ensure that data is easily accessible at the sites where it is needed.

In a Distributed DBMS