Database & SQL
SQL queries, database design, and optimization.
Categories
- Core CSDifficulty: Easy
Quiz: DBMS Revision Sheet
Prepare more deliberately for Core CS revision with Quiz: DBMS Revision Sheet. This 6-question topic-wise practice test turns the topic into a structured practice session. The attempt uses a 7-minute timer and easy difficulty so you can practise with clear conditions.
🧠 What you will practise: The questions cover transactions and ACID guarantees; deadlocks and process scheduling; database normalization and schema design; indexes and query optimization; and joins, subqueries, and window functions. Scenario prompts ask you to choose an approach, recognise its limits, and explain the production consequences clearly.
Review missed scenarios by asking what assumption failed, which alternative fits better, and how you would explain that choice aloud.6 questions7 minPractice - Database & SQLDifficulty: Medium
GROUP BY, HAVING, and Aggregation Logic
Prepare more deliberately for database interviews and SQL revision with GROUP BY, HAVING, and Aggregation Logic. This 20-question interview-focused practice test turns the topic into a structured practice session. The attempt uses a 30-minute timer so you can practise with clear conditions.
⚙️ Skills tested: The questions cover joins, subqueries, and window functions; AI-assisted testing, refactoring, and code review; failure handling and graceful degradation; and indexes and query optimization. Questions connect definitions with implementation choices, failure cases, trade-offs, and the concise reasoning expected in technical discussions.
After the attempt, write down the decisions you could not justify clearly and revisit the underlying constraints before retrying; the answer explanations provide a focused review path.20 questions30 minStart test - Database & SQLDifficulty: Medium
Schema Design and Relationship Modeling
Use Schema Design and Relationship Modeling as a 20-question checkpoint for database interviews and SQL revision. The attempt uses a 30-minute timer so you can practise with clear conditions.
🎯 Coverage: The questions cover database normalization and schema design; AI-assisted testing, refactoring, and code review; failure handling and graceful degradation; and indexes and query optimization. Rather than rewarding definitions alone, the set tests how concepts behave under constraints, failures, and changing requirements.
Convert the result into an interview checklist covering definitions, edge cases, operational risks, and defensible trade-offs; the answer explanations provide a focused review path.20 questions30 minStart test - Database & SQLDifficulty: Hard
Advanced Indexing and Query Troubleshooting
Prepare more deliberately for database interviews and SQL revision with Advanced Indexing and Query Troubleshooting. This 20-question interview-focused practice test turns the topic into a structured practice session. The attempt uses a 30-minute timer and hard difficulty so you can practise with clear conditions.
🎯 Coverage: The questions cover AI-assisted testing, refactoring, and code review; caching and hot-key protection; failure handling and graceful degradation; database replication and sharding; and indexes and query optimization. Use the scenarios to practise separating a plausible shortcut from an approach that remains maintainable at production scale.
Treat incorrect answers as design-review notes: identify the overlooked constraint and practise defending a safer alternative; the answer explanations provide a focused review path.20 questions30 minStart test - Database & SQLDifficulty: Hard
Deadlocks, Retries, and Consistency Bugs
Prepare more deliberately for database interviews and SQL revision with Deadlocks, Retries, and Consistency Bugs. This 20-question interview-focused practice test turns the topic into a structured practice session. The attempt uses a 30-minute timer and hard difficulty so you can practise with clear conditions.
⚙️ Skills tested: The questions cover deadlocks and process scheduling; transactions and ACID guarantees; AI-assisted testing, refactoring, and code review; concurrency, threads, and synchronization; failure handling and graceful degradation; and indexes and query optimization. The progression moves from core terminology to debugging, boundary decisions, and trade-offs that surface in real interviews.
After the attempt, write down the decisions you could not justify clearly and revisit the underlying constraints before retrying; the answer explanations provide a focused review path.20 questions30 minStart test - Database & SQLDifficulty: Medium
Stored Procedures and Database Functions
Use Stored Procedures and Database Functions as a 20-question checkpoint for database interviews and SQL revision. The attempt uses a 30-minute timer so you can practise with clear conditions.
🧠 What you will practise: The questions cover AI-assisted testing, refactoring, and code review; failure handling and graceful degradation; and indexes and query optimization. The progression moves from core terminology to debugging, boundary decisions, and trade-offs that surface in real interviews.
Review missed scenarios by asking what assumption failed, which alternative fits better, and how you would explain that choice aloud; the answer explanations provide a focused review path.20 questions30 minStart test - Database & SQLDifficulty: Medium
SQL vs NoSQL Design Decisions
Prepare more deliberately for database interviews and SQL revision with SQL vs NoSQL Design Decisions. This 20-question interview-focused practice test turns the topic into a structured practice session. The attempt uses a 30-minute timer so you can practise with clear conditions.
⚙️ Skills tested: The questions cover AI-assisted testing, refactoring, and code review; database replication and sharding; failure handling and graceful degradation; transactions and ACID guarantees; and indexes and query optimization. Use the scenarios to practise separating a plausible shortcut from an approach that remains maintainable at production scale.
Treat incorrect answers as design-review notes: identify the overlooked constraint and practise defending a safer alternative; the answer explanations provide a focused review path.20 questions30 minStart test - Database & SQLDifficulty: Hard
Database Interview Mock: DBMS Concepts Round
Prepare more deliberately for database interviews and SQL revision with Database Interview Mock: DBMS Concepts Round. This 30-question interview-focused practice test turns the topic into a structured practice session. The attempt uses a 45-minute timer and hard difficulty so you can practise with clear conditions.
🎯 Coverage: The questions cover AI-assisted testing, refactoring, and code review; database replication and sharding; indexes and query optimization; caching and hot-key protection; failure handling and graceful degradation; and consistency and availability trade-offs. Use the scenarios to practise separating a plausible shortcut from an approach that remains maintainable at production scale.
Use the result to find weak concepts, rehearse concise explanations, and revisit the trade-offs you would need to defend in an interview or production discussion; the answer explanations provide a focused review path.30 questions45 minStart test - System DesignDifficulty: Medium
Database Indexing: B-Tree vs Hash, and When Indexes Hurt — Quiz
Open this quiz for a focused run from the selected collection.
10 questions30 minStart test - Database & SQLDifficulty: Hard
Subqueries, CTEs, and Set Operations
Move beyond surface-level recall with Subqueries, CTEs, and Set Operations in this 20-question interview-focused practice test. It is structured for database interviews and SQL revision, and the attempt uses a 30-minute timer and hard difficulty so you can practise with clear conditions.
🎯 Coverage: The questions cover joins, subqueries, and window functions; AI-assisted testing, refactoring, and code review; failure handling and graceful degradation; and indexes and query optimization. The questions emphasise diagnosis and decision-making: what to choose, what can fail, and what evidence supports the trade-off.
Treat incorrect answers as design-review notes: identify the overlooked constraint and practise defending a safer alternative; the answer explanations provide a focused review path.20 questions30 minStart test - Database & SQLDifficulty: Medium
Normalization and Data Integrity
Use Normalization and Data Integrity as a 20-question checkpoint for database interviews and SQL revision. The attempt uses a 30-minute timer so you can practise with clear conditions.
🧠 What you will practise: The questions cover database normalization and schema design; AI-assisted testing, refactoring, and code review; failure handling and graceful degradation; indexes and query optimization; and cell biology, genetics, and evolution. Questions connect definitions with implementation choices, failure cases, trade-offs, and the concise reasoning expected in technical discussions.
Convert the result into an interview checklist covering definitions, edge cases, operational risks, and defensible trade-offs; the answer explanations provide a focused review path.20 questions30 minStart test - Database & SQLDifficulty: Medium
Indexing Fundamentals and Access Patterns
Move beyond surface-level recall with Indexing Fundamentals and Access Patterns in this 20-question interview-focused practice test. It is structured for database interviews and SQL revision, and the attempt uses a 30-minute timer so you can practise with clear conditions.
⚙️ Skills tested: The questions cover indexes and query optimization; AI-assisted testing, refactoring, and code review; failure handling and graceful degradation; and trees, graphs, and traversals. Rather than rewarding definitions alone, the set tests how concepts behave under constraints, failures, and changing requirements.
Use the result to find weak concepts, rehearse concise explanations, and revisit the trade-offs you would need to defend in an interview or production discussion; the answer explanations provide a focused review path.20 questions30 minStart test - Database & SQLDifficulty: Hard
Transactional Workflows and Idempotency
Build confidence in Transactional Workflows and Idempotency with this 20-question interview-focused practice test, designed for database interviews and SQL revision. The attempt uses a 30-minute timer and hard difficulty so you can practise with clear conditions.
🧠 What you will practise: The questions cover transactions and ACID guarantees; AI-assisted testing, refactoring, and code review; concurrency, threads, and synchronization; encapsulation and invariants; asynchronous processing and queues; and failure handling and graceful degradation. Rather than rewarding definitions alone, the set tests how concepts behave under constraints, failures, and changing requirements.
Treat incorrect answers as design-review notes: identify the overlooked constraint and practise defending a safer alternative; the answer explanations provide a focused review path.20 questions30 minStart test - Database & SQLDifficulty: Hard
Triggers, Auditing, and Side Effects
Use Triggers, Auditing, and Side Effects as a 20-question checkpoint for database interviews and SQL revision. The attempt uses a 30-minute timer and hard difficulty so you can practise with clear conditions.
📚 Inside the quiz: The questions cover AI-assisted testing, refactoring, and code review; failure handling and graceful degradation; recursion and backtracking; and indexes and query optimization. Use the scenarios to practise separating a plausible shortcut from an approach that remains maintainable at production scale.
Use the result to find weak concepts, rehearse concise explanations, and revisit the trade-offs you would need to defend in an interview or production discussion; the answer explanations provide a focused review path.20 questions30 minStart test - Database & SQLDifficulty: Medium
Document, Key-Value, and Graph Data Models
Use Document, Key-Value, and Graph Data Models as a 20-question checkpoint for database interviews and SQL revision. The attempt uses a 30-minute timer so you can practise with clear conditions.
⚙️ Skills tested: The questions cover trees, graphs, and traversals; data modelling and storage choices; AI-assisted testing, refactoring, and code review; observability and operational signals; failure handling and graceful degradation; and indexes and query optimization. Rather than rewarding definitions alone, the set tests how concepts behave under constraints, failures, and changing requirements.
Use weaker areas as prompts for deeper revision, then retry when you can connect each concept to a concrete implementation consequence; the answer explanations provide a focused review path.20 questions30 minStart test - Database & SQLDifficulty: Hard
Database Interview Mock: Performance and Transactions Round
Use Database Interview Mock: Performance and Transactions Round as a 30-question checkpoint for database interviews and SQL revision. The attempt uses a 45-minute timer and hard difficulty so you can practise with clear conditions.
🧠 What you will practise: The questions cover transactions and ACID guarantees; AI-assisted testing, refactoring, and code review; joins, subqueries, and window functions; indexes and query optimization; caching and hot-key protection; and observability and operational signals. Use the scenarios to practise separating a plausible shortcut from an approach that remains maintainable at production scale.
Treat incorrect answers as design-review notes: identify the overlooked constraint and practise defending a safer alternative; the answer explanations provide a focused review path.30 questions45 minStart test - TechnologyDifficulty: Medium
MCP Server vs. Modern Cloud Platforms: A Strategic Comparison for Hybrid and Multi-Cloud Deployments — Quiz
Open this quiz for a focused run from the selected collection.
10 questions30 minStart test - Database & SQLDifficulty: Hard
Window Functions and Reporting Queries
Build confidence in Window Functions and Reporting Queries with this 20-question interview-focused practice test, designed for database interviews and SQL revision. The attempt uses a 30-minute timer and hard difficulty so you can practise with clear conditions.
🧠 What you will practise: The questions cover joins, subqueries, and window functions; AI-assisted testing, refactoring, and code review; failure handling and graceful degradation; and indexes and query optimization. Rather than rewarding definitions alone, the set tests how concepts behave under constraints, failures, and changing requirements.
Convert the result into an interview checklist covering definitions, edge cases, operational risks, and defensible trade-offs; the answer explanations provide a focused review path.20 questions30 minStart test - Database & SQLDifficulty: Hard
Keys, Constraints, and Schema Evolution
Use Keys, Constraints, and Schema Evolution as a 20-question checkpoint for database interviews and SQL revision. The attempt uses a 30-minute timer and hard difficulty so you can practise with clear conditions.
⚙️ Skills tested: The questions cover cell biology, genetics, and evolution; database normalization and schema design; AI-assisted testing, refactoring, and code review; state-machine modelling; failure handling and graceful degradation; and trees, graphs, and traversals. Scenario prompts ask you to choose an approach, recognise its limits, and explain the production consequences clearly.
Use weaker areas as prompts for deeper revision, then retry when you can connect each concept to a concrete implementation consequence; the answer explanations provide a focused review path.20 questions30 minStart test - Database & SQLDifficulty: Hard
Query Plans, Scans, and Selectivity
Use Query Plans, Scans, and Selectivity as a 20-question checkpoint for database interviews and SQL revision. The attempt uses a 30-minute timer and hard difficulty so you can practise with clear conditions.
📚 Inside the quiz: The questions cover indexes and query optimization; AI-assisted testing, refactoring, and code review; and failure handling and graceful degradation. Use the scenarios to practise separating a plausible shortcut from an approach that remains maintainable at production scale.
Treat incorrect answers as design-review notes: identify the overlooked constraint and practise defending a safer alternative; the answer explanations provide a focused review path.20 questions30 minStart test - Database & SQLDifficulty: Medium
ACID Transactions and Isolation Levels
Move beyond surface-level recall with ACID Transactions and Isolation Levels in this 20-question interview-focused practice test. It is structured for database interviews and SQL revision, and the attempt uses a 30-minute timer so you can practise with clear conditions.
📚 Inside the quiz: The questions cover transactions and ACID guarantees; AI-assisted testing, refactoring, and code review; concurrency, threads, and synchronization; observability and operational signals; failure handling and graceful degradation; and indexes and query optimization. Use the scenarios to practise separating a plausible shortcut from an approach that remains maintainable at production scale.
Review missed scenarios by asking what assumption failed, which alternative fits better, and how you would explain that choice aloud; the answer explanations provide a focused review path.20 questions30 minStart test - Database & SQLDifficulty: Hard
Database-Side Logic and Security Boundaries
Prepare more deliberately for database interviews and SQL revision with Database-Side Logic and Security Boundaries. This 20-question interview-focused practice test turns the topic into a structured practice session. The attempt uses a 30-minute timer and hard difficulty so you can practise with clear conditions.
🧠 What you will practise: The questions cover AI-assisted testing, refactoring, and code review; failure handling and graceful degradation; concurrency, threads, and synchronization; transactions and ACID guarantees; indexes and query optimization; and exceptions and resource handling. Scenario prompts ask you to choose an approach, recognise its limits, and explain the production consequences clearly.
Use weaker areas as prompts for deeper revision, then retry when you can connect each concept to a concrete implementation consequence; the answer explanations provide a focused review path.20 questions30 minStart test - Database & SQLDifficulty: Hard
Replication, Sharding, and Hot Partitions
Use Replication, Sharding, and Hot Partitions as a 20-question checkpoint for database interviews and SQL revision. The attempt uses a 30-minute timer and hard difficulty so you can practise with clear conditions.
📚 Inside the quiz: The questions cover database replication and sharding; AI-assisted testing, refactoring, and code review; consistency and availability trade-offs; failure handling and graceful degradation; encryption, hashing, and secure transport; and indexes and query optimization. The sequence is built to sharpen accuracy, pacing, and the habit of checking assumptions before committing to an answer.
Convert the result into an interview checklist covering definitions, edge cases, operational risks, and defensible trade-offs; the answer explanations provide a focused review path.20 questions30 minStart test - Database & SQLDifficulty: Medium
Database Interview Mock: Core SQL Round
Use Database Interview Mock: Core SQL Round as a 30-question checkpoint for database interviews and SQL revision. The attempt uses a 45-minute timer so you can practise with clear conditions.
⚙️ Skills tested: The questions cover AI-assisted testing, refactoring, and code review; joins, subqueries, and window functions; transactions and ACID guarantees; failure handling and graceful degradation; deadlocks and process scheduling; and database normalization and schema design. Scenario prompts ask you to choose an approach, recognise its limits, and explain the production consequences clearly.
Use weaker areas as prompts for deeper revision, then retry when you can connect each concept to a concrete implementation consequence; the answer explanations provide a focused review path.30 questions45 minStart test - Database & SQLDifficulty: Medium
SQL SELECT, WHERE, and Sorting Fundamentals
Build confidence in SQL SELECT, WHERE, and Sorting Fundamentals with this 20-question interview-focused practice test, designed for database interviews and SQL revision. The attempt uses a 30-minute timer so you can practise with clear conditions.
📚 Inside the quiz: The questions cover AI-assisted testing, refactoring, and code review; failure handling and graceful degradation; and indexes and query optimization. Scenario prompts ask you to choose an approach, recognise its limits, and explain the production consequences clearly.
Convert the result into an interview checklist covering definitions, edge cases, operational risks, and defensible trade-offs; the answer explanations provide a focused review path.20 questions30 minStart test - Database & SQLDifficulty: Medium
SQL Joins and Relationship Queries
Build confidence in SQL Joins and Relationship Queries with this 20-question interview-focused practice test, designed for database interviews and SQL revision. The attempt uses a 30-minute timer so you can practise with clear conditions.
🧠 What you will practise: The questions cover joins, subqueries, and window functions; AI-assisted testing, refactoring, and code review; failure handling and graceful degradation; and indexes and query optimization. Scenario prompts ask you to choose an approach, recognise its limits, and explain the production consequences clearly.
Convert the result into an interview checklist covering definitions, edge cases, operational risks, and defensible trade-offs; the answer explanations provide a focused review path.20 questions30 minStart test - Database & SQLDifficulty: Hard
Denormalization and Read Model Design
Move beyond surface-level recall with Denormalization and Read Model Design in this 20-question interview-focused practice test. It is structured for database interviews and SQL revision, and the attempt uses a 30-minute timer and hard difficulty so you can practise with clear conditions.
⚙️ Skills tested: The questions cover AI-assisted testing, refactoring, and code review; database normalization and schema design; failure handling and graceful degradation; and indexes and query optimization. Rather than rewarding definitions alone, the set tests how concepts behave under constraints, failures, and changing requirements.
Review missed scenarios by asking what assumption failed, which alternative fits better, and how you would explain that choice aloud; the answer explanations provide a focused review path.20 questions30 minStart test - Database & SQLDifficulty: Hard
Pagination, Joins, and Performance Tuning
Use Pagination, Joins, and Performance Tuning as a 20-question checkpoint for database interviews and SQL revision. The attempt uses a 30-minute timer and hard difficulty so you can practise with clear conditions.
🎯 Coverage: The questions cover joins, subqueries, and window functions; AI-assisted testing, refactoring, and code review; failure handling and graceful degradation; and indexes and query optimization. The questions emphasise diagnosis and decision-making: what to choose, what can fail, and what evidence supports the trade-off.
After the attempt, write down the decisions you could not justify clearly and revisit the underlying constraints before retrying; the answer explanations provide a focused review path.20 questions30 minStart test - Database & SQLDifficulty: Hard
Locks, MVCC, and Concurrent Writes
Build confidence in Locks, MVCC, and Concurrent Writes with this 20-question interview-focused practice test, designed for database interviews and SQL revision. The attempt uses a 30-minute timer and hard difficulty so you can practise with clear conditions.
🎯 Coverage: The questions cover concurrency, threads, and synchronization; AI-assisted testing, refactoring, and code review; deadlocks and process scheduling; transactions and ACID guarantees; failure handling and graceful degradation; and indexes and query optimization. Questions connect definitions with implementation choices, failure cases, trade-offs, and the concise reasoning expected in technical discussions.
Review missed scenarios by asking what assumption failed, which alternative fits better, and how you would explain that choice aloud; the answer explanations provide a focused review path.20 questions30 minStart test - Database & SQLDifficulty: Medium
Views and Materialized Views
Use Views and Materialized Views as a 20-question checkpoint for database interviews and SQL revision. The attempt uses a 30-minute timer so you can practise with clear conditions.
🧠 What you will practise: The questions cover AI-assisted testing, refactoring, and code review; observability and operational signals; failure handling and graceful degradation; and indexes and query optimization. Questions connect definitions with implementation choices, failure cases, trade-offs, and the concise reasoning expected in technical discussions.
Review missed scenarios by asking what assumption failed, which alternative fits better, and how you would explain that choice aloud; the answer explanations provide a focused review path.20 questions30 minStart test - Database & SQLDifficulty: Hard
Distributed Consistency and NoSQL Trade-offs
Build confidence in Distributed Consistency and NoSQL Trade-offs with this 20-question interview-focused practice test, designed for database interviews and SQL revision. The attempt uses a 30-minute timer and hard difficulty so you can practise with clear conditions.
📚 Inside the quiz: The questions cover AI-assisted testing, refactoring, and code review; indexes and query optimization; failure handling and graceful degradation; consistency and availability trade-offs; and trees, graphs, and traversals. The questions emphasise diagnosis and decision-making: what to choose, what can fail, and what evidence supports the trade-off.
After the attempt, write down the decisions you could not justify clearly and revisit the underlying constraints before retrying; the answer explanations provide a focused review path.20 questions30 minStart test - Database & SQLDifficulty: Medium
SQL Constraints, Data Types, and NULL Handling
Use SQL Constraints, Data Types, and NULL Handling as a 20-question checkpoint for database interviews and SQL revision. The attempt uses a 30-minute timer so you can practise with clear conditions.
⚙️ Skills tested: The questions cover AI-assisted testing, refactoring, and code review; failure handling and graceful degradation; transactions and ACID guarantees; and indexes and query optimization. The questions emphasise diagnosis and decision-making: what to choose, what can fail, and what evidence supports the trade-off.
Use the result to find weak concepts, rehearse concise explanations, and revisit the trade-offs you would need to defend in an interview or production discussion; the answer explanations provide a focused review path.20 questions30 minStart test - Database & SQLDifficulty: Medium
SQL CRUD, Safety, and Query Readability
Use SQL CRUD, Safety, and Query Readability as a 20-question checkpoint for database interviews and SQL revision. The attempt uses a 30-minute timer so you can practise with clear conditions.
🎯 Coverage: The questions cover AI-assisted testing, refactoring, and code review; failure handling and graceful degradation; indexes and query optimization; and joins, subqueries, and window functions. Rather than rewarding definitions alone, the set tests how concepts behave under constraints, failures, and changing requirements.
After the attempt, write down the decisions you could not justify clearly and revisit the underlying constraints before retrying; the answer explanations provide a focused review path.20 questions30 minStart test - Database & SQLDifficulty: Hard
Applied SQL Fundamentals Practice
Build confidence in Applied SQL Fundamentals Practice with this 20-question interview-focused practice test, designed for database interviews and SQL revision. The attempt uses a 30-minute timer and hard difficulty so you can practise with clear conditions.
🧠 What you will practise: The questions cover AI-assisted testing, refactoring, and code review; failure handling and graceful degradation; web security and input protection; indexes and query optimization; and spreadsheet cleanup and data analysis. Scenario prompts ask you to choose an approach, recognise its limits, and explain the production consequences clearly.
Use weaker areas as prompts for deeper revision, then retry when you can connect each concept to a concrete implementation consequence; the answer explanations provide a focused review path.20 questions30 minStart test
Explore DBMS and SQL
Continue with DBMS and SQL topics like SQL, transactions, indexes, database design across courses, notes, and mock tests.