SQL vs NoSQL — Concept Check
Questions on SQL vs NoSQL. SQL databases (relational) provide ACID transactions, structured schemas, and powerful joins. NoSQL databases (document, key-value, wide-column, graph) offer flexible schemas, horizontal scalability, and optimised access patterns at the cost of some consistency guarantees.
Questions in this quiz
8 questions on SQL vs NoSQL — Concept Check. Work through them here, then start the quiz to answer them and see your score.
1.A company's e-commerce platform uses PostgreSQL for transactions but struggles with high write loads for user activity logs. What is a suitable solution?
- AUse Redis for fast key-value lookups
- BSwitch to MongoDB for flexible schema support
- CMigrate to Neo4j for relationship queries
- DAdopt Cassandra for massive write throughput
2.Which database type is best suited for handling social network data with complex relationships?
- ADocument Store
- BGraph Database
- CKey-Value Store
- DWide-Column Store
3.A team needs to perform complex joins and maintain strict data integrity. Which database should they choose?
- ACassandra
- BRedis
- CPostgreSQL
- DMongoDB
4.A developer is using Redis to store session data but notices data loss after a server crash. What could be the reason?
- ARedis requires manual schema enforcement
- BRedis lacks horizontal scalability
- CRedis uses in-memory storage
- DRedis does not support ACID transactions
5.Why might a team choose MongoDB over a relational database for a product catalog?
- ATo enforce strict data integrity
- BTo handle evolving product schemas
- CFor complex joins across tables
- DTo ensure ACID transactions
6.A service using DynamoDB experiences inconsistent read results. What might be causing this?
- ADynamoDB does not support any consistency
- BDynamoDB uses eventual consistency by default
- CDynamoDB is not horizontally scalable
- DDynamoDB lacks schema enforcement
7.Which database type would be least suitable for a time-series data application requiring high write throughput?
- AMongoDB
- BInfluxDB
- CPostgreSQL
- DCassandra
8.A developer claims that MongoDB ensures ACID transactions for all operations. What is the issue with this statement?
- AMongoDB only supports ACID in specific scenarios
- BMongoDB lacks horizontal scalability
- CMongoDB enforces strict schemas
- DMongoDB is a key-value store