Database Types (Data+): SQL vs NoSQL Quiz

1. In relational databases, normalization primarily prevents which issue?

Slow query performance

Data redundancy and anomalies

Horizontal scaling

Network latency

2. A startup needs to handle millions of users with varying data structures. Which database approach aligns best?

Rigid SQL schema

Scalable NoSQL with flexible schema

Single-server relational database

File-based storage system

3. In SQL, a JOIN operation combines rows from multiple tables. Which NoSQL pattern achieves similar functionality?

Denormalization and embedding

Sharding

Replication

Indexing

4. Cassandra and HBase are examples of which NoSQL architecture?

Document store

Key-value store

Column-family store

Graph database

5. What is sharding in the context of NoSQL databases?

Creating backup copies of data

Dividing data across multiple servers based on a shard key

Encrypting sensitive database fields

Compressing old records

6. Which database type is best for time-stamped sensor data or metrics?

Document store

Relational database

Time-series database

Graph database

7. Which Database Types (Data+) model uses eventual consistency instead of immediate consistency?

SQL relational databases

NoSQL distributed systems

In-memory databases

Data warehouses

8. Which database model uses structured tables with predefined schemas and ACID compliance?

NoSQL

Relational (SQL)

Graph database

Time-series database

9. What does CAP theorem state about distributed databases?

All systems must support Consistency, Availability, and Partition tolerance

Only two of three properties can be guaranteed simultaneously

NoSQL databases always prioritize availability

SQL databases achieve all three properties

10. In SQL databases, what enforces relationships between tables?

Document references

Foreign keys

Index partitions

Sharding rules

11. What is the primary advantage of horizontal scaling in NoSQL databases?

Improved query performance on joins

Distributing data across multiple servers for increased capacity

Enhanced ACID transaction support

Simpler schema design

12. MongoDB is an example of which Database Types (Data+) category?

Relational database

Document-oriented NoSQL database

Graph database

In-memory cache

13. Which NoSQL database type stores data as key-value pairs?

Document store

Column-family store

Key-value store

Search engine

14. NoSQL databases are best suited for which type of data?

Highly structured financial records

Unstructured or semi-structured data with flexible schemas

Data requiring strict foreign key constraints

Time-synchronized transactional systems

15. What does ACID stand for in database transactions?

Atomicity, Consistency, Isolation, Durability

Availability, Concurrency, Integration, Data

Automation, Compression, Index, Distribution

Aggregation, Clustering, Integrity, Design

16. Redis is commonly used as which type of data store?

Document database

In-memory cache and key-value store

Graph database

Full-text search engine

17. Which database type is optimized for storing and querying relationships between data entities?

Relational database

Key-value store

Graph database

Time-series database

18. A SQL database transaction fails midway. What ACID property ensures the database reverts to its prior state?

Consistency

Atomicity

Isolation

Durability

19. Which statement best describes a data lake?

A normalized SQL database for transactional systems

A repository storing raw, unstructured data in its native format

An in-memory cache layer

A backup system for critical databases

20. What is the primary trade-off when choosing NoSQL over SQL?

NoSQL sacrifices consistency for scalability and flexibility

SQL is always faster than NoSQL

NoSQL cannot handle structured data

SQL databases cannot scale horizontally

Database Quiz: Can You Master SQL vs NoSQL?

1. In relational databases, normalization primarily prevents which issue?

2.

What first name or nickname would you like us to use?

2. A startup needs to handle millions of users with varying data structures. Which database approach aligns best?

3. In SQL, a JOIN operation combines rows from multiple tables. Which NoSQL pattern achieves similar functionality?

4. Cassandra and HBase are examples of which NoSQL architecture?

5. What is sharding in the context of NoSQL databases?

6. Which database type is best for time-stamped sensor data or metrics?

7. Which Database Types (Data+) model uses eventual consistency instead of immediate consistency?

8. Which database model uses structured tables with predefined schemas and ACID compliance?

9. What does CAP theorem state about distributed databases?

10. In SQL databases, what enforces relationships between tables?

11. What is the primary advantage of horizontal scaling in NoSQL databases?

12. MongoDB is an example of which Database Types (Data+) category?

13. Which NoSQL database type stores data as key-value pairs?

14. NoSQL databases are best suited for which type of data?

15. What does ACID stand for in database transactions?

16. Redis is commonly used as which type of data store?

17. Which database type is optimized for storing and querying relationships between data entities?

18. A SQL database transaction fails midway. What ACID property ensures the database reverts to its prior state?

19. Which statement best describes a data lake?

20. What is the primary trade-off when choosing NoSQL over SQL?