NoSQL Databases Questions and Answers

Q: As per the CAP theorem, distributed database can provide ...................... to achieve high scalability.

The answer is At least two among (A), (B) and (C).Eric Brewer's CAP theorem says that a distributed data store cannot guarantee consistency, availability and partition tolerance all at once. When the network partitions, it must give up either consistency or availability. So a design achieves two of the three properties: CA, CP or AP. Highly scalable systems spread over many machines must tolerate partitions, and then choose between consistency and availability.The option is worded 'at least two', but its sense is a pair of the three, which is what the theorem allows. Each of the other options names a single property, which understates what a system can provide.

Q: Which of the following statement(s) is/are correct ?(i) Documents can contain many different key value pairs, or key array pairs but not nested documents(ii) Mango DB was official drivers for a variety of popular programming languages and development environments(iii) When compared to relational databases, No SQL databases are more scalable and provide superior performance

Statements (ii) and (iii) are correct, so the answer is (ii) and (iii).Statement (i) is false: a MongoDB document can contain key-value pairs, arrays and nested (embedded) documents, and embedding related data in one document is one of the main features of the document model.Statement (ii) is true: MongoDB (printed 'Mango DB') provides official drivers for many popular programming languages and environments. Statement (iii) reflects the usual claim for NoSQL systems: they are built to scale horizontally across many servers and to give high performance on large volumes of data, compared with traditional relational databases.

Q: Which of the following is a wide column store ?

The wide column store is Cassandra.Apache Cassandra organises data in tables of rows whose columns can vary from row to row, grouped into column families, the wide-column model it took from Google's Bigtable along with the distributed design of Amazon's Dynamo.Riak is a distributed key-value store. MongoDB (printed 'Mango DB') is a document store holding JSON-like documents. Redis is an in-memory key-value store with rich data structures. None of them is a wide column store.

Q: Which NoSQL database is known for its ability to handle complex queries and data analysis ?

The key gives (D) MongoDB.MongoDB is a document database. It stores records as JSON-like documents and offers a rich query language with filters on any field, indexes of several kinds and an aggregation pipeline (grouping, joining, filtering, transforming), which is what supports complex queries and data analysis on the data in place.dBase is an early desktop database management system, not a NoSQL database. HBase is a wide-column store on Hadoop built around reads and scans by row key, with no rich query language of its own. Couchbase is the closest rival, since it offers a SQL-like query language over JSON documents, so the item is not watertight, but the key names MongoDB as the better-known answer.

As per the CAP theorem, distributed database can provide ...................... to achieve high scalability.

A.Availability
B.Consistency
C.Partition tolerance
D.At least two among (A), (B) and (C)

Exam Year(s)

MH SET - 2019, SET Exam - 2019,

Answer: D

The answer is At least two among (A), (B) and (C).

Eric Brewer's CAP theorem says that a distributed data store cannot guarantee consistency, availability and partition tolerance all at once. When the network partitions, it must give up either consistency or availability. So a design achieves two of the three properties: CA, CP or AP. Highly scalable systems spread over many machines must tolerate partitions, and then choose between consistency and availability.

The option is worded 'at least two', but its sense is a pair of the three, which is what the theorem allows. Each of the other options names a single property, which understates what a system can provide.

Discuss in Forum

For storing the information about networks, such as social connections, the stores used are ...............

A.Key-value
B.Graph
C.Wide-column
D.Document

Exam Year(s)

MH SET - 2020, SET Exam - 2020,

Answer: B

Network information such as social connections is stored in Graph stores.

Graph databases (for example Neo4j) store entities as nodes and relationships as edges, so queries like 'friends of friends' follow links directly instead of joining tables.

Key-value stores hold opaque values under keys, wide-column stores hold sparse tables of rows and column families, and document stores hold JSON-like documents. They can store relationships, but not as natively as a graph store.

Discuss in Forum

Which of the following statement(s) is/are correct ?

(i) Documents can contain many different key value pairs, or key array pairs but not nested documents
(ii) Mango DB was official drivers for a variety of popular programming languages and development environments
(iii) When compared to relational databases, No SQL databases are more scalable and provide superior performance

A.(i) and (ii)
B.(i) and (iii)
C.(ii) and (iii)
D.(i), (ii) and (iii)

Exam Year(s)

MH SET - 2021, SET Exam - 2021,

Answer: C

Statements (ii) and (iii) are correct, so the answer is (ii) and (iii).

Statement (i) is false: a MongoDB document can contain key-value pairs, arrays and nested (embedded) documents, and embedding related data in one document is one of the main features of the document model.

Statement (ii) is true: MongoDB (printed 'Mango DB') provides official drivers for many popular programming languages and environments. Statement (iii) reflects the usual claim for NoSQL systems: they are built to scale horizontally across many servers and to give high performance on large volumes of data, compared with traditional relational databases.

Discuss in Forum

Which of the following is a wide column store ?

A.Cassandra
B.Riak
C.Mango DB
D.Redis

Exam Year(s)

MH SET - 2023, SET Exam - 2023,

Answer: A

The wide column store is Cassandra.

Apache Cassandra organises data in tables of rows whose columns can vary from row to row, grouped into column families, the wide-column model it took from Google's Bigtable along with the distributed design of Amazon's Dynamo.

Riak is a distributed key-value store. MongoDB (printed 'Mango DB') is a document store holding JSON-like documents. Redis is an in-memory key-value store with rich data structures. None of them is a wide column store.

Discuss in Forum

Which NoSQL database is known for its ability to handle complex queries and data analysis ?

A.Dbase
B.HBase
C.Couchbase
D.MongoDB

Exam Year(s)

MH SET - 2025, SET Exam - 2025,

Answer: D

The key gives (D) MongoDB.

MongoDB is a document database. It stores records as JSON-like documents and offers a rich query language with filters on any field, indexes of several kinds and an aggregation pipeline (grouping, joining, filtering, transforming), which is what supports complex queries and data analysis on the data in place.

dBase is an early desktop database management system, not a NoSQL database. HBase is a wide-column store on Hadoop built around reads and scans by row key, with no rich query language of its own. Couchbase is the closest rival, since it offers a SQL-like query language over JSON documents, so the item is not watertight, but the key names MongoDB as the better-known answer.

Discuss in Forum

Loading…

Topics

Other Subjects

Tags: NoSQL Databases Questions and Answers || NoSQL Databases MCQ Questions and Answers || NoSQL Databases GK Questions and Answers || NoSQL Databases GK MCQ Questions || NoSQL Databases Multiple Choice Questions and Answers || NoSQL Databases GK || GK on NoSQL Databases || Big Data Analytics Questions and Answers || Big Data Analytics MCQ Questions and Answers || Big Data Analytics GK Questions and Answers || GK on Big Data Analytics

NoSQL Databases Questions and Answers

Topics

Other Subjects

About Us

Stay informed about all important Dates & Notifications