Q#1: NoSQL databases are primarily designed for:
(A) Large-scale, unstructured, or semi-structured data
(B) Only relational data
(C) Backup management
(D) Indexing only
Answer: (A) Large-scale, unstructured, or semi-structured data
Q#2: NoSQL stands for:
(A) Not Only SQL
(B) Non-Structured SQL
(C) Non-Secure SQL
(D) Normalized SQL
Answer: (A) Not Only SQL
Q#3: Main advantage of NoSQL databases is:
(A) High scalability and flexibility for diverse data types
(B) Enforcing strict normalization
(C) Backup efficiency only
(D) Indexing only
Answer: (A) High scalability and flexibility for diverse data types
Q#4: Key types of NoSQL databases include:
(A) Document, Key-Value, Column-Family, Graph
(B) Relational, Indexed, View, Stored Procedure
(C) Backup, Encryption, Index, Trigger
(D) Row, Column, File, Disk
Answer: (A) Document, Key-Value, Column-Family, Graph
Q#5: Key-Value stores in NoSQL:
(A) Store data as key-value pairs for fast lookup
(B) Store only documents
(C) Store only graphs
(D) Store only relational tables
Answer: (A) Store data as key-value pairs for fast lookup
Q#6: Document databases store:
(A) Semi-structured data in JSON, XML, or BSON format
(B) Only key-value pairs
(C) Only graphs
(D) Only relational tables
Answer: (A) Semi-structured data in JSON, XML, or BSON format
Q#7: Column-Family NoSQL databases are optimized for:
(A) Analytical queries on large datasets
(B) Only transaction processing
(C) Backup operations
(D) Encryption only
Answer: (A) Analytical queries on large datasets
Q#8: Graph databases are used for:
(A) Storing and querying relationships between entities
(B) Only key-value storage
(C) Only documents
(D) Only backups
Answer: (A) Storing and querying relationships between entities
Q#9: CAP theorem in NoSQL states that a distributed system can provide only two of the following:
(A) Consistency, Availability, Partition tolerance
(B) Backup, Encryption, Indexing
(C) Row, Column, Table
(D) Normalization, Triggers, Views
Answer: (A) Consistency, Availability, Partition tolerance
Q#10: BASE in NoSQL stands for:
(A) Basically Available, Soft state, Eventual consistency
(B) Backup Always Secure Encryption
(C) Binary Access Structured Entity
(D) Backup, Archive, Store, Encrypt
Answer: (A) Basically Available, Soft state, Eventual consistency
Q#11: NoSQL databases are preferred over SQL when:
(A) Data is large-scale, unstructured, and requires horizontal scaling
(B) Strict ACID compliance is needed
(C) Only small tables are used
(D) Only indexing is required
Answer: (A) Data is large-scale, unstructured, and requires horizontal scaling
Q#12: Key-Value NoSQL databases examples include:
(A) Redis, Riak, DynamoDB
(B) MySQL, PostgreSQL
(C) Oracle, SQL Server
(D) MongoDB only
Answer: (A) Redis, Riak, DynamoDB
Q#13: Document NoSQL database examples include:
(A) MongoDB, CouchDB
(B) MySQL, Oracle
(C) Redis, Riak
(D) Cassandra only
Answer: (A) MongoDB, CouchDB
Q#14: Column-Family NoSQL database examples include:
(A) Cassandra, HBase
(B) MySQL, PostgreSQL
(C) Redis, Riak
(D) MongoDB only
Answer: (A) Cassandra, HBase
Q#15: Graph database examples include:
(A) Neo4j, OrientDB, ArangoDB
(B) MySQL, Oracle
(C) Redis only
(D) MongoDB only
Answer: (A) Neo4j, OrientDB, ArangoDB
Q#16: NoSQL databases typically relax:
(A) ACID constraints in favor of scalability
(B) Backup only
(C) Indexing only
(D) Encryption only
Answer: (A) ACID constraints in favor of scalability
Q#17: Advantages of NoSQL include:
(A) Schema flexibility, high scalability, and fast access to large volumes of data
(B) Enforcing strict normalization
(C) Backup only
(D) Encryption only
Answer: (A) Schema flexibility, high scalability, and fast access to large volumes of data
Q#18: Disadvantages of NoSQL include:
(A) Less mature tooling, weaker consistency guarantees, and limited standardization
(B) Backup only
(C) Indexing only
(D) Encryption only
Answer: (A) Less mature tooling, weaker consistency guarantees, and limited standardization
Q#19: Eventual consistency in NoSQL means:
(A) All nodes will converge to the same value over time
(B) Data is always immediately consistent
(C) Backup only
(D) Indexing only
Answer: (A) All nodes will converge to the same value over time
Q#20: Horizontal scaling in NoSQL involves:
(A) Adding more servers to handle increased load
(B) Increasing RAM on a single server
(C) Backup only
(D) Encryption only
Answer: (A) Adding more servers to handle increased load
Q#21: Vertical scaling in NoSQL involves:
(A) Increasing resources (CPU, RAM) on a single server
(B) Adding more servers
(C) Backup only
(D) Encryption only
Answer: (A) Increasing resources (CPU, RAM) on a single server
Q#22: Key-Value databases are best for:
(A) Simple lookup operations
(B) Complex joins
(C) Graph traversals
(D) Backup only
Answer: (A) Simple lookup operations
Q#23: Document databases are best for:
(A) Semi-structured hierarchical data
(B) Only key-value pairs
(C) Graph relationships
(D) Backup only
Answer: (A) Semi-structured hierarchical data
Q#24: Graph databases are ideal for:
(A) Social networks, recommendation systems, and network analysis
(B) Only key-value lookups
(C) Only documents
(D) Backup only
Answer: (A) Social networks, recommendation systems, and network analysis
Q#25: Column-Family stores are inspired by:
(A) Bigtable from Google
(B) MySQL
(C) Oracle
(D) PostgreSQL
Answer: (A) Bigtable from Google
Q#26: NoSQL databases support:
(A) Flexible or dynamic schemas
(B) Only fixed schemas
(C) Only normalized tables
(D) Only backup files
Answer: (A) Flexible or dynamic schemas
Q#27: ACID vs BASE: NoSQL prefers BASE because:
(A) It allows better scalability and availability
(B) It ensures strict consistency
(C) Only backup
(D) Only indexing
Answer: (A) It allows better scalability and availability
Q#28: NoSQL databases are commonly used in:
(A) Big data applications, real-time analytics, and distributed systems
(B) Only small desktop apps
(C) Only relational reporting
(D) Backup only
Answer: (A) Big data applications, real-time analytics, and distributed systems
Q#29: Sharding in NoSQL databases refers to:
(A) Splitting data across multiple servers for horizontal scaling
(B) Backup operations
(C) Indexing only
(D) Encryption only
Answer: (A) Splitting data across multiple servers for horizontal scaling
Q#30: Main purpose of NoSQL databases is:
(A) Handle large, distributed, and diverse datasets efficiently
(B) Enforce strict normalization
(C) Only backup
(D) Only encryption
Answer: (A) Handle large, distributed, and diverse datasets efficiently