NoSQL Databases (e.g., MongoDB, Cassandra) MCQsBy: Prof. Dr. Fazal Rehman | Last updated: May 14, 2025 20 Score: 0 Attempted: 0/20 Subscribe 1. What is a primary characteristic of NoSQL databases compared to traditional relational databases? (A) They support complex SQL queries (B) They use a fixed schema (C) They are designed for scalability and flexibility (D) They store data in tables with rows and columns 2. Which of the following is a type of NoSQL database? (A) MySQL (B) PostgreSQL (C) MongoDB (D) Oracle Database 3. What does ACID stand for in the context of database transactions? (A) Atomic, Consistent, Isolated, Durable (B) Automated, Consistent, Isolated, Distributed (C) Atomic, Continuous, Isolated, Distributed (D) Automated, Consistent, Isolated, Durable 4. Which type of NoSQL database is optimized for storing and retrieving key-value pairs? (A) Document-oriented (B) Column-family (C) Graph-based (D) Key-value 5. What is a common use case for a document-oriented NoSQL database like MongoDB? (A) Storing complex relationships between entities (B) Storing and retrieving hierarchical data structures (C) Storing data in tables with fixed schemas (D) Performing complex joins across multiple tables 6. What is BSON in the context of MongoDB? (A) Binary Structure Object Notation (B) Binary Serialized Object Notation (C) Basic Structure Object Notation (D) Binary Serialized Object Namespace 7. Which statement about MongoDB’s schema is true? (A) MongoDB enforces a fixed schema for all collections (B) MongoDB allows flexible schemas for collections (C) MongoDB requires SQL queries to retrieve data (D) MongoDB uses a traditional relational database schema 8. How do you perform aggregation operations in MongoDB? (A) Using the JOIN keyword (B) Using the MERGE keyword (C) Using the AGGREGATE framework (D) Using the GROUP BY clause 9. What is a sharding key in MongoDB? (A) A unique identifier for each document (B) A field used to distribute data across multiple shards (C) A field used for indexing purposes (D) A primary key in a collection 10. How do you create an index on a field in a MongoDB collection? (A) createIndex() (B) addIndex() (C) index.create() (D) ensureIndex() 11. What is the primary data model used in Cassandra? (A) Document-oriented (B) Key-value (C) Column-family (D) Graph-based 12. Which of the following is a characteristic of Cassandra’s architecture? (A) Strong consistency model (B) Single point of failure (C) Centralized data storage (D) Master-slave replication 13. How does Cassandra ensure fault tolerance and high availability? (A) By using a master-slave architecture (B) By replicating data across multiple nodes (C) By enforcing strict ACID transactions (D) By storing data in a single node 14. Which query language is used to interact with Cassandra? (A) SQL (B) CQL (Cassandra Query Language) (C) Cypher (D) NoQL 15. What is a key advantage of using Cassandra for distributed databases? (A) High write latency (B) Linear scalability (C) Limited data replication (D) Structured schema requirement 16. What is a key difference between MongoDB and Cassandra? (A) MongoDB uses a document-oriented data model, while Cassandra uses a column-family data model (B) Cassandra supports complex SQL queries, while MongoDB does not (C) MongoDB does not support replication, while Cassandra does (D) Cassandra enforces a fixed schema, while MongoDB allows flexible schemas 17. Which NoSQL database is suitable for applications requiring high availability and linear scalability? (A) MongoDB (B) Cassandra (C) Redis (D) Neo4j 18. What is a common disadvantage of using NoSQL databases? (A) Limited scalability (B) Fixed schema (C) Complex querying capabilities (D) Eventual consistency 19. How do NoSQL databases typically handle transactions compared to traditional relational databases? (A) NoSQL databases support full ACID transactions (B) NoSQL databases have limited support for ACID transactions (C) NoSQL databases use a centralized architecture (D) NoSQL databases enforce strict schema constraints 20. Which NoSQL database is known for its in-memory data storage and high-speed data access? (A) MongoDB (B) Cassandra (C) Redis (D) HBase Related Posts:Big Data Technologies and NoSQL Databases MCQsNoSQL databases MCQs in DBMSWhich of the following are the simplest NoSQL databases?Which of the following is not nosql database?Cloud Databases and Database as a Service (DBaaS) MCQsDistributed Databases MCQs in DBMS