Multiple Choice Questions on NoSQL Database Concepts

📚 Quick Study Guide

• 🌐 Definition: NoSQL databases (Not Only SQL) are non-relational databases that provide a mechanism for storage and retrieval of data that is modeled in means other than the tabular relations used in relational databases.
• ⚙️ Key Features: Schema-less, horizontally scalable, distributed, and often open-source.
• 🔑 Types: Key-value stores (e.g., Redis), document databases (e.g., MongoDB), column-family stores (e.g., Cassandra), and graph databases (e.g., Neo4j).
• 🚀 CAP Theorem: Consistency, Availability, Partition Tolerance. NoSQL databases often prioritize two out of three.
• ⏱️ ACID vs. BASE: Relational databases emphasize ACID (Atomicity, Consistency, Isolation, Durability), while NoSQL databases often follow BASE (Basically Available, Soft state, Eventually consistent).
• 📈 Scaling: Horizontal scaling (adding more machines) is a common strategy.
• 💡 Use Cases: Big data, real-time applications, content management, mobile apps.

🧪 Practice Quiz

1. Which of the following is NOT a type of NoSQL database?
   1. Key-Value Store
   2. Document Database
   3. Relational Database
   4. Graph Database
2. Which of the following is a characteristic of NoSQL databases?
   1. Strict Schema
   2. Horizontal Scalability
   3. ACID Properties
   4. Complex Joins
3. What does CAP theorem stand for?
   1. Consistency, Availability, Performance
   2. Consistency, Accuracy, Partitioning
   3. Consistency, Availability, Partition Tolerance
   4. Concurrency, Availability, Performance
4. Which NoSQL database type is best suited for storing social network connections?
   1. Key-Value Store
   2. Document Database
   3. Column-Family Store
   4. Graph Database
5. What does BASE stand for in the context of NoSQL databases?
   1. Basic Availability, Soft state, Eventual consistency
   2. Basically Available, Strong consistency, Eventually consistent
   3. Basically Available, Soft state, Eventually consistent
   4. Basic Availability, Strong state, Eventual consistency
6. Which of the following is an example of a Document Database?
   1. Redis
   2. Cassandra
   3. MongoDB
   4. Neo4j
7. Which scaling method is commonly used in NoSQL databases?
   1. Vertical Scaling
   2. Diagonal Scaling
   3. Horizontal Scaling
   4. Centralized Scaling