Practice Library
All MCQs
Browse exam-wise, subject-wise, and country-wise MCQs with explanations.
Choose an option to check your answer.
A.
a non-relational database approach designed for flexible schemas and scalable data models
B.
a database that can run only on one laptop
C.
a database that never stores data
D.
a database that forbids all indexing
Show Answer
Correct Answer: A. a non-relational database approach designed for flexible schemas and scalable data models
Explanation:
This statement is correct because NoSQL database means that a non-relational database approach designed for flexible schemas and scalable data models.
Choose an option to check your answer.
A.
a non-relational database approach designed for flexible schemas and scalable data models
B.
a database that forbids all indexing
C.
a database that can run only on one laptop
D.
a database that never stores data
Show Answer
Correct Answer: A. a non-relational database approach designed for flexible schemas and scalable data models
Explanation:
NoSQL database is used in Advanced DBMS because a non-relational database approach designed for flexible schemas and scalable data models.
Choose an option to check your answer.
A.
a database that forbids all indexing
B.
a database that can run only on one laptop
C.
a database that never stores data
D.
a non-relational database approach designed for flexible schemas and scalable data models
Show 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.
A.
binary access, strict execution, and full encryption describe SQL syntax
B.
backup, archive, storage, and export describe recovery only
C.
basically available, soft state, and eventual consistency describe many NoSQL systems
D.
B-tree, aggregation, sort, and execution describe indexing only
Show 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.
A.
binary access, strict execution, and full encryption describe SQL syntax
B.
basically available, soft state, and eventual consistency describe many NoSQL systems
C.
B-tree, aggregation, sort, and execution describe indexing only
D.
backup, archive, storage, and export describe recovery only
Show 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.
A.
B-tree, aggregation, sort, and execution describe indexing only
B.
basically available, soft state, and eventual consistency describe many NoSQL systems
C.
backup, archive, storage, and export describe recovery only
D.
binary access, strict execution, and full encryption describe SQL syntax
Show 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.
A.
every database must use only SQL
B.
NoSQL databases cannot be replicated
C.
a distributed system cannot simultaneously guarantee strong consistency, availability, and partition tolerance under network partition
D.
indexes always remove the need for consistency
Show Answer
Correct Answer: C. a distributed system cannot simultaneously guarantee strong consistency, availability, and partition tolerance under network partition
Explanation:
This statement is correct because CAP theorem means that a distributed system cannot simultaneously guarantee strong consistency, availability, and partition tolerance under network partition.
Choose an option to check your answer.
A.
a distributed system cannot simultaneously guarantee strong consistency, availability, and partition tolerance under network partition
B.
NoSQL databases cannot be replicated
C.
indexes always remove the need for consistency
D.
every database must use only SQL
Show Answer
Correct Answer: A. a distributed system cannot simultaneously guarantee strong consistency, availability, and partition tolerance under network partition
Explanation:
CAP theorem is used in Advanced DBMS because a distributed system cannot simultaneously guarantee strong consistency, availability, and partition tolerance under network partition.
Choose an option to check your answer.
A.
NoSQL databases cannot be replicated
B.
every database must use only SQL
C.
indexes always remove the need for consistency
D.
a distributed system cannot simultaneously guarantee strong consistency, availability, and partition tolerance under network partition
Show Answer
Correct Answer: D. a distributed system cannot simultaneously guarantee strong consistency, availability, and partition tolerance under network partition
Explanation:
The correct answer explains CAP theorem in the context of Distributed Databases.
Choose an option to check your answer.
A.
coordinating concurrent transactions that access data at multiple sites
B.
running all transactions without isolation
C.
using only a single local lock table always
D.
denying every remote read
Show Answer
Correct Answer: A. coordinating concurrent transactions that access data at multiple sites
Explanation:
This statement is correct because distributed concurrency control means that coordinating concurrent transactions that access data at multiple sites.
Choose an option to check your answer.
A.
coordinating concurrent transactions that access data at multiple sites
B.
denying every remote read
C.
using only a single local lock table always
D.
running all transactions without isolation
Show Answer
Correct Answer: A. coordinating concurrent transactions that access data at multiple sites
Explanation:
distributed concurrency control is used in Advanced DBMS because coordinating concurrent transactions that access data at multiple sites.
Choose an option to check your answer.
A.
using only a single local lock table always
B.
coordinating concurrent transactions that access data at multiple sites
C.
running all transactions without isolation
D.
denying every remote read
Show Answer
Correct Answer: B. coordinating concurrent transactions that access data at multiple sites
Explanation:
The correct answer explains distributed concurrency control in the context of Distributed Databases.
