Practice Library
All MCQs
Browse exam-wise, subject-wise, and country-wise MCQs with explanations.
Choose an option to check your answer.
Correct Answer: D. transforming a distributed query into operations on fragments at relevant sites
Explanation:
This statement is correct because data localization means that transforming a distributed query into operations on fragments at relevant sites.
Choose an option to check your answer.
Correct Answer: A. transforming a distributed query into operations on fragments at relevant sites
Explanation:
data localization is used in Advanced DBMS because transforming a distributed query into operations on fragments at relevant sites.
Choose an option to check your answer.
Correct Answer: D. transforming a distributed query into operations on fragments at relevant sites
Explanation:
The correct answer explains data localization in the context of Distributed Databases.
Choose an option to check your answer.
Correct Answer: A. processing a query whose required data may reside at multiple sites
Explanation:
This statement is correct because distributed query processing means that processing a query whose required data may reside at multiple sites.
Choose an option to check your answer.
Correct Answer: A. processing a query whose required data may reside at multiple sites
Explanation:
distributed query processing is used in Advanced DBMS because processing a query whose required data may reside at multiple sites.
Choose an option to check your answer.
Correct Answer: B. processing a query whose required data may reside at multiple sites
Explanation:
The correct answer explains distributed query processing in the context of Distributed Databases.
Choose an option to check your answer.
Correct Answer: A. a distributed protocol with prepare and commit/abort phases to ensure atomic commitment
Explanation:
This statement is correct because two-phase commit means that a distributed protocol with prepare and commit/abort phases to ensure atomic commitment.
Choose an option to check your answer.
Correct Answer: C. a distributed protocol with prepare and commit/abort phases to ensure atomic commitment
Explanation:
two-phase commit is used in Advanced DBMS because a distributed protocol with prepare and commit/abort phases to ensure atomic commitment.
Choose an option to check your answer.
Correct Answer: C. a distributed protocol with prepare and commit/abort phases to ensure atomic commitment
Explanation:
The correct answer explains two-phase commit in the context of Distributed Databases.
Choose an option to check your answer.
Correct Answer: A. users need not know which copy of replicated data is being accessed
Explanation:
This statement is correct because replication transparency means that users need not know which copy of replicated data is being accessed.
Choose an option to check your answer.
Correct Answer: B. users need not know which copy of replicated data is being accessed
Explanation:
replication transparency is used in Advanced DBMS because users need not know which copy of replicated data is being accessed.
Choose an option to check your answer.
Correct Answer: B. users need not know which copy of replicated data is being accessed
Explanation:
The correct answer explains replication transparency in the context of Distributed Databases.