MCQ Collection
Advance Database Management Systems MCQs
Practice Advance Database Management Systems questions with answers and explanations.
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. basically available, soft state, and eventual consistency describe many NoSQL systems
Explanation:
The correct answer explains BASE properties in the context of NoSQL.
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. 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: B. basically available, soft state, and eventual consistency describe many NoSQL systems
Explanation:
BASE properties is used in Advanced DBMS because basically available, soft state, and eventual consistency describe many NoSQL systems.
Choose an option to check your answer.
Correct Answer: C. a logically related database whose data is stored across multiple networked sites
Explanation:
The correct answer explains distributed database in the context of Distributed Databases.
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. basically available, soft state, and eventual consistency describe many NoSQL systems
Explanation:
This statement is correct because BASE properties means that basically available, soft state, and eventual consistency describe many NoSQL systems.
Choose an option to check your answer.
Correct Answer: B. a logically related database whose data is stored across multiple networked sites
Explanation:
distributed database is used in Advanced DBMS because a logically related database whose data is stored across multiple networked sites.
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: D. a non-relational database approach designed for flexible schemas and scalable data models
Explanation:
The correct answer explains NoSQL database in the context of NoSQL.
Choose an option to check your answer.
Correct Answer: C. a logically related database whose data is stored across multiple networked sites
Explanation:
This statement is correct because distributed database means that a logically related database whose data is stored across multiple networked sites.
