QuizzesSQL vs NoSQL — Concept Check
intermediate
system-design

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.

8 minutes 8 questions Pass at 70%
Time Limit
8 minutes - timer starts when you begin
Change Answers Freely
Revisit and change any answer before submitting
Full Review After Submit
Correct answers and explanations shown for every question
Auto-submit on timeout
Quiz submits automatically when time runs out

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. 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. 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. 3.A team needs to perform complex joins and maintain strict data integrity. Which database should they choose?

    • ACassandra
    • BRedis
    • CPostgreSQL
    • DMongoDB
  4. 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. 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. 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. 7.Which database type would be least suitable for a time-series data application requiring high write throughput?

    • AMongoDB
    • BInfluxDB
    • CPostgreSQL
    • DCassandra
  8. 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