Database & SQL
SQL queries, database design, and optimization.
Categories
Search or pick a category to refine.
Quiz: DBMS Revision Sheet
Revise normalization, ACID, indexes, joins, and locking.
GROUP BY, HAVING, and Aggregation Logic
A focused Joins, Subqueries & Aggregations mock test on group by, having, and aggregation logic with medium to hard scenario-based questions.
Schema Design and Relationship Modeling
A focused Database Design & Normalization mock test on schema design and relationship modeling with medium to hard scenario-based questions.
Advanced Indexing and Query Troubleshooting
A focused Indexing & Query Performance mock test on advanced indexing and query troubleshooting with medium to hard scenario-based questions.
Deadlocks, Retries, and Consistency Bugs
A focused Transactions, Locks & Concurrency mock test on deadlocks, retries, and consistency bugs with medium to hard scenario-based questions.
Stored Procedures and Database Functions
A focused Stored Procedures, Views & Triggers mock test on stored procedures and database functions with medium to hard scenario-based questions.
SQL vs NoSQL Design Decisions
A focused NoSQL & Distributed Databases mock test on sql vs nosql design decisions with medium to hard scenario-based questions.
Database Interview Mock: DBMS Concepts Round
A full-length database interview mock: dbms concepts round covering scenarios, trade-offs, debugging, and production decision-making.
Database Indexing: B-Tree vs Hash, and When Indexes Hurt — Quiz
Open this quiz for a focused run from the selected collection.
Subqueries, CTEs, and Set Operations
A focused Joins, Subqueries & Aggregations mock test on subqueries, ctes, and set operations with medium to hard scenario-based questions.
Normalization and Data Integrity
A focused Database Design & Normalization mock test on normalization and data integrity with medium to hard scenario-based questions.
Indexing Fundamentals and Access Patterns
A focused Indexing & Query Performance mock test on indexing fundamentals and access patterns with medium to hard scenario-based questions.
Transactional Workflows and Idempotency
A focused Transactions, Locks & Concurrency mock test on transactional workflows and idempotency with medium to hard scenario-based questions.
Triggers, Auditing, and Side Effects
A focused Stored Procedures, Views & Triggers mock test on triggers, auditing, and side effects with medium to hard scenario-based questions.
Document, Key-Value, and Graph Data Models
A focused NoSQL & Distributed Databases mock test on document, key-value, and graph data models with medium to hard scenario-based questions.
Database Interview Mock: Performance and Transactions Round
A full-length database interview mock: performance and transactions round covering scenarios, trade-offs, debugging, and production decision-making.
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.
Window Functions and Reporting Queries
A focused Joins, Subqueries & Aggregations mock test on window functions and reporting queries with medium to hard scenario-based questions.
Keys, Constraints, and Schema Evolution
A focused Database Design & Normalization mock test on keys, constraints, and schema evolution with medium to hard scenario-based questions.
Query Plans, Scans, and Selectivity
A focused Indexing & Query Performance mock test on query plans, scans, and selectivity with medium to hard scenario-based questions.
ACID Transactions and Isolation Levels
A focused Transactions, Locks & Concurrency mock test on acid transactions and isolation levels with medium to hard scenario-based questions.
Database-Side Logic and Security Boundaries
A focused Stored Procedures, Views & Triggers mock test on database-side logic and security boundaries with medium to hard scenario-based questions.
Replication, Sharding, and Hot Partitions
A focused NoSQL & Distributed Databases mock test on replication, sharding, and hot partitions with medium to hard scenario-based questions.
Database Interview Mock: Core SQL Round
A full-length database interview mock: core sql round covering scenarios, trade-offs, debugging, and production decision-making.
SQL SELECT, WHERE, and Sorting Fundamentals
A focused SQL Fundamentals mock test on sql select, where, and sorting fundamentals with medium to hard scenario-based questions.
SQL Joins and Relationship Queries
A focused Joins, Subqueries & Aggregations mock test on sql joins and relationship queries with medium to hard scenario-based questions.
Denormalization and Read Model Design
A focused Database Design & Normalization mock test on denormalization and read model design with medium to hard scenario-based questions.
Pagination, Joins, and Performance Tuning
A focused Indexing & Query Performance mock test on pagination, joins, and performance tuning with medium to hard scenario-based questions.
Locks, MVCC, and Concurrent Writes
A focused Transactions, Locks & Concurrency mock test on locks, mvcc, and concurrent writes with medium to hard scenario-based questions.
Views and Materialized Views
A focused Stored Procedures, Views & Triggers mock test on views and materialized views with medium to hard scenario-based questions.
Distributed Consistency and NoSQL Trade-offs
A focused NoSQL & Distributed Databases mock test on distributed consistency and nosql trade-offs with medium to hard scenario-based questions.
SQL Constraints, Data Types, and NULL Handling
A focused SQL Fundamentals mock test on sql constraints, data types, and null handling with medium to hard scenario-based questions.
SQL CRUD, Safety, and Query Readability
A focused SQL Fundamentals mock test on sql crud, safety, and query readability with medium to hard scenario-based questions.
Applied SQL Fundamentals Practice
A focused SQL Fundamentals mock test on applied sql fundamentals practice with medium to hard scenario-based questions.
Explore DBMS and SQL
Continue with DBMS and SQL topics like SQL, transactions, indexes, database design across courses, notes, and mock tests.