Question

Which rule for distributed databases states that the performance of functions such as adding sites, changing versions of DBMSs, creating backups, and modifying hardware should not require planned shutdowns of the entire distributed database?

A. Continuous operation
B. Local autonomy
C. Location transparency
D. Fragmentation transparency

Answer 1

Answer:

Option (A) Continuous operation

Explanation:

• Option (A) Continuous operation is the feature that is discussed in the question.
• Continuous Operation is the feature of the Distributed DBMS where multiple operations can be done without a planned shutdown of the entire distributed database system.

• Option (B) Local Autonomy is the feature where the autonomy of that particular node / part of the distributed database lies with the people there.
• They manage and control that part of the database there itself.
• Option (C) Location Transparency is the feature where the individual can access the database from any site.
• This means location independence. The whole database can be accessed from any site as if the database is physically located at that site.
• Option (D) Fragmentation Transparency is the feature where the Distributed Database is Fragment Independent.
• The database is independent of the number of fragments and the fragmentation way.
• The data is accessible irrespective of the fragments.
• So , option (A) is true and (B),(C) and (D) are false.