Question 1
Which of the following best describes NoSQL databases?
1
They use structured query language (SQL) like relational databases.
2
They provide flexible schemas for handling unstructured and semi-structured data.
3
They do not support distributed architectures.
4
They are optimized for structured data only.
Question 2
Which of the following is NOT a type of NoSQL database?
1
Column-Family Store
2
Key-Value Store
3
Relational Database
4
Document Store
Question 3
Which of the following is an example of a Key-Value Store?
1
Cassandra
2
MongoDB
3
Neo4j
4
Redis
Question 4
Which feature makes NoSQL databases highly scalable?
1
Horizontal Scaling
2
Single Server Architecture
3
Vertical Scaling
4
Fixed Schema
Question 5
Which of the following statements about NoSQL and SQL databases is TRUE?
1
NoSQL is better for large-scale, distributed applications.
2
NoSQL databases always provide better performance than SQL databases.
3
NoSQL databases use relational tables to store data.
4
SQL databases cannot store unstructured data.
Question 6
Which NoSQL database uses JSON-like documents to store data?
1
Cassandra
2
Redis
3
HBase
4
MongoDB
Question 7
Which query language does MongoDB use?
1
CQL
2
SQL
3
SPARQL
4
MQL
Question 8
Which consistency model is most commonly used in NoSQL databases?
1
Immediate Consistency
2
Strong Consistency
3
Serializability
4
Eventual Consistency
Question 9
Which of the following applications is best suited for NoSQL databases?
1
E-commerce Product Catalogs
2
Accounting Systems
3
Banking Transactions
4
Enterprise Resource Planning (ERP)
Question 10
Which of the following is NOT an example of a key-value database?
1
Memcached
2
DynamoDB
3
PostgreSQL
4
Cassandra
Question 11
Which of the following is the most suitable key-value database for large-scale event logging and analytics?
1
Apache Cassandra
2
HashTable
3
SQLite
4
MongoDB
Question 12
Which of the following is a key difference between SQL and NoSQL databases?
1
SQL databases are schema-less, NoSQL databases require a strict schema
2
SQL databases use structured query language, NoSQL uses flexible data models
3
SQL databases store data in documents, NoSQL stores data in tables
4
SQL databases do not support transactions, while NoSQL does
Question 13
Which ACID property ensures that once a transaction is committed, it remains so even in case of system failure?
1
Isolation
2
Consistency
3
Atomicity
4
Durability
Question 14
What is the main goal of normalization in a database?
1
To store data in a single large table
2
To increase redundancy
3
To minimize redundancy and improve data integrity
4
To reduce data integrity
Question 15
What does ACID stand for in DBMS?
1
Accuracy, Consistency, Isolation, Database
2
Atomicity, Consistency, Isolation, Durability
3
Automation, Control, Integrity, Dependency
4
Access, Control, Integrity, Data
Question 16
Which of the following is NOT a type of database model?
1
Graph-based
2
Hierarchical
3
Linear
4
Network
Question 17
Which of the following is an advantage of NoSQL databases over traditional RDBMS?
1
Schema flexibility
2
Better horizontal scalability
3
Handling unstructured data
4
All of the above