Practice Library
All MCQs
Browse exam-wise, subject-wise, and country-wise MCQs with explanations.
Choose an option to check your answer.
Correct Answer: A. storing copies of data at multiple sites to improve availability or performance
Explanation:
This statement is correct because replication means that storing copies of data at multiple sites to improve availability or performance.
Choose an option to check your answer.
Correct Answer: C. storing copies of data at multiple sites to improve availability or performance
Explanation:
replication is used in Advanced DBMS because storing copies of data at multiple sites to improve availability or performance.
Choose an option to check your answer.
Correct Answer: A. storing copies of data at multiple sites to improve availability or performance
Explanation:
The correct answer explains replication in the context of Distributed Databases.
Choose an option to check your answer.
Correct Answer: D. splitting a relation by columns while preserving a way to reconstruct it
Explanation:
This statement is correct because vertical fragmentation means that splitting a relation by columns while preserving a way to reconstruct it.
Choose an option to check your answer.
Correct Answer: C. splitting a relation by columns while preserving a way to reconstruct it
Explanation:
vertical fragmentation is used in Advanced DBMS because splitting a relation by columns while preserving a way to reconstruct it.
Choose an option to check your answer.
Correct Answer: B. splitting a relation by columns while preserving a way to reconstruct it
Explanation:
The correct answer explains vertical fragmentation in the context of Distributed Databases.
Choose an option to check your answer.
Correct Answer: D. splitting a relation by rows using predicates
Explanation:
This statement is correct because horizontal fragmentation means that splitting a relation by rows using predicates.
Choose an option to check your answer.
Correct Answer: B. splitting a relation by rows using predicates
Explanation:
horizontal fragmentation is used in Advanced DBMS because splitting a relation by rows using predicates.
Choose an option to check your answer.
Correct Answer: A. splitting a relation by rows using predicates
Explanation:
The correct answer explains horizontal fragmentation in the context of Distributed Databases.
Choose an option to check your answer.
Correct Answer: A. dividing a large table or index into smaller manageable pieces
Explanation:
This statement is correct because partitioning means that dividing a large table or index into smaller manageable pieces.
Choose an option to check your answer.
Correct Answer: B. dividing a large table or index into smaller manageable pieces
Explanation:
partitioning is used in Advanced DBMS because dividing a large table or index into smaller manageable pieces.
Choose an option to check your answer.
Correct Answer: D. dividing a large table or index into smaller manageable pieces
Explanation:
The correct answer explains partitioning in the context of Physical Design and Tuning.
