| 1 | What does it mean for Redis transactions to lack full rollback support, and how does this differ from transactions in a traditional relational database? Redis › Transactions | Redis | Transactions | Intermediate |
| 2 | How do Redis transactions interact with Redis Cluster when the queued commands involve keys located on different shards? Redis › Transactions | Redis | Transactions | Advanced |
| 3 | What does ACID stand for, and what does each letter represent in the context of database transactions? SQL Server › Transactions & ACID | SQL Server | Transactions & ACID | Beginner |
| 4 | How do long running transactions negatively impact overall system performance, and what strategies help avoid this problem? SQL Server › Transactions & ACID | SQL Server | Transactions & ACID | Advanced |
| 5 | How do you implement database transactions in Node.js using Sequelize to ensure multiple related writes succeed or fail together? Node.js › Databases & ORMs (MongoDB/Mongoose, SQL/Sequelize) | Node.js | Databases & ORMs (MongoDB/Mongoose, SQL/Sequelize) | Intermediate |
| 6 | How do database transactions work in PDO, and why are they important for ensuring multiple related database operations either all succeed together or all fail together? PHP › PDO & Databases | PHP | PDO & Databases | Intermediate |
| 7 | What is the Saga pattern, and how does it manage distributed transactions across multiple Node.js microservices? Node.js › Architecture & Design Patterns | Node.js | Architecture & Design Patterns | Advanced |
| 8 | What is a database deadlock, and how might it occur between two concurrent transactions in a Node.js application? Node.js › Databases | Node.js | Databases | Advanced |
| 9 | How should you properly implement database transactions in sqflite to ensure several genuinely related separate operations either all fully succeed together, or all genuinely fail together entirely, maintaining your overall data's own genuine consistency? Flutter › SQLite & Local Databases (sqflite) | Flutter | SQLite & Local Databases (sqflite) | Advanced |
| 10 | What is a Redis transaction, and how do the MULTI and EXEC commands work together to create one? Redis › Transactions | Redis | Transactions | Beginner |
| 11 | How do you cancel a queued Redis transaction before it executes, and what command is used for this? Redis › Transactions | Redis | Transactions | Beginner |
| 12 | How does the WATCH command enable optimistic locking within a Redis transaction? Redis › Transactions | Redis | Transactions | Intermediate |
| 13 | What is a practical real world example where a Redis transaction ensures data consistency across multiple related keys? Redis › Transactions | Redis | Transactions | Intermediate |
| 14 | When would you choose a Lua script over a MULTI and EXEC transaction to achieve atomicity in Redis? Redis › Transactions | Redis | Transactions | Advanced |
| 15 | What is a transaction in SQL Server, and why is grouping multiple statements into one important? SQL Server › Transactions & ACID | SQL Server | Transactions & ACID | Beginner |
| 16 | How do you use a SAVE TRANSACTION savepoint within a larger transaction to allow partial rollback of just a portion of the work? SQL Server › Transactions & ACID | SQL Server | Transactions & ACID | Intermediate |
| 17 | What is the difference between an implicit and an explicit transaction in SQL Server? SQL Server › Transactions & ACID | SQL Server | Transactions & ACID | Intermediate |
| 18 | How do you check whether a transaction is currently active and view its properties within a session? SQL Server › Transactions & ACID | SQL Server | Transactions & ACID | Intermediate |
| 19 | How would you design a distributed transaction that needs to span operations across two different database servers, and what additional complexity does this introduce? SQL Server › Transactions & ACID | SQL Server | Transactions & ACID | Advanced |
| 20 | What are the three main types of backups in SQL Server, and what does each one capture? SQL Server › Backup & Recovery | SQL Server | Backup & Recovery | Beginner |
| 21 | How do you restore a SQL Server database from a full backup file? SQL Server › Backup & Recovery | SQL Server | Backup & Recovery | Beginner |
| 22 | How does a TRY CATCH block work in SQL Server, and why is it useful? SQL Server › Error Handling with TRY CATCH | SQL Server | Error Handling with TRY CATCH | Beginner |
| 23 | Does data stored in a memory optimized table get lost if the SQL Server instance restarts? SQL Server › In-Memory OLTP (Memory-Optimized Tables) | SQL Server | In-Memory OLTP (Memory-Optimized Tables) | Beginner |
| 24 | What is a lock in SQL Server, and why does the database engine use locks? SQL Server › Isolation & Locking | SQL Server | Isolation & Locking | Beginner |
| 25 | What are the four standard transaction isolation levels in SQL Server, and what does isolation level actually control? SQL Server › Isolation & Locking | SQL Server | Isolation & Locking | Beginner |
| 26 | What does the MERGE statement do in SQL Server, and why is it called an upsert operation? SQL Server › Merge Statement (Upsert) | SQL Server | Merge Statement (Upsert) | Beginner |
| 27 | What is a deadlock in SQL Server, and why does it happen? SQL Server › Deadlocks | SQL Server | Deadlocks | Beginner |
| 28 | How does SQL Server decide which transaction becomes the deadlock victim? SQL Server › Deadlocks | SQL Server | Deadlocks | Beginner |
| 29 | Why would you use a Lua script with Redis instead of just sending several separate commands from your application? Redis › Lua Scripting | Redis | Lua Scripting | Beginner |
| 30 | What is AOF, or append only file, persistence, and how does it differ from RDB snapshots? Redis › Persistence (RDB/AOF) | Redis | Persistence (RDB/AOF) | Beginner |
| 31 | What is pipelining, and how does it improve throughput when performing many operations against Redis? Redis › Redis Performance Tuning & Benchmarking | Redis | Redis Performance Tuning & Benchmarking | Beginner |
| 32 | What are the three recovery models available in SQL Server, and how do they affect your backup strategy? SQL Server › Backup & Recovery | SQL Server | Backup & Recovery | Intermediate |
| 33 | How would you perform a point in time restore to recover a database to the exact moment just before an accidental data deletion? SQL Server › Backup & Recovery | SQL Server | Backup & Recovery | Intermediate |
| 34 | How do you combine a TRY CATCH block with a transaction to ensure the database is properly rolled back if an error occurs partway through? SQL Server › Error Handling with TRY CATCH | SQL Server | Error Handling with TRY CATCH | Intermediate |
| 35 | What is the difference between using THROW and RAISERROR to raise a custom error in SQL Server? SQL Server › Error Handling with TRY CATCH | SQL Server | Error Handling with TRY CATCH | Intermediate |
| 36 | How does the concurrency model of In-Memory OLTP differ from traditional disk based tables, and why does this improve performance? SQL Server › In-Memory OLTP (Memory-Optimized Tables) | SQL Server | In-Memory OLTP (Memory-Optimized Tables) | Intermediate |
| 37 | What is a deadlock, and how does SQL Server automatically handle one when it occurs? SQL Server › Isolation & Locking | SQL Server | Isolation & Locking | Intermediate |
| 38 | What is the difference between an optimistic and a pessimistic approach to handling concurrency, and where does SQL Server's snapshot isolation fit into this? SQL Server › Isolation & Locking | SQL Server | Isolation & Locking | Intermediate |
| 39 | What are lock escalation and its potential impact on a busy system? SQL Server › Isolation & Locking | SQL Server | Isolation & Locking | Intermediate |
| 40 | What are some known issues or caveats with the MERGE statement that developers should be aware of before relying on it heavily? SQL Server › Merge Statement (Upsert) | SQL Server | Merge Statement (Upsert) | Intermediate |
| 41 | How do you safely test a MERGE statement before running it against real production data? SQL Server › Merge Statement (Upsert) | SQL Server | Merge Statement (Upsert) | Intermediate |
| 42 | What is the difference between a batch and a transaction in T-SQL, and how does the GO keyword relate to batches? SQL Server › T-SQL Fundamentals & Syntax | SQL Server | T-SQL Fundamentals & Syntax | Intermediate |
| 43 | What error does an application receive when its transaction is chosen as a deadlock victim, and how should the application respond? SQL Server › Deadlocks | SQL Server | Deadlocks | Intermediate |
| 44 | How do you use pipelining in a Redis client library to reduce the overhead of sending many commands to the server? Redis › Connection Pooling & Client Libraries | Redis | Connection Pooling & Client Libraries | Intermediate |
| 45 | How do you call other Redis commands from within a Lua script, and what restrictions apply to this? Redis › Lua Scripting | Redis | Lua Scripting | Intermediate |
| 46 | How do you decide between synchronous commit mode and asynchronous commit mode for a specific replica in an Always On Availability Group? SQL Server › Always On Availability Groups | SQL Server | Always On Availability Groups | Advanced |
| 47 | How would you design a comprehensive backup and recovery strategy for a large, business critical database with strict recovery time and recovery point objectives? SQL Server › Backup & Recovery | SQL Server | Backup & Recovery | Advanced |
| 48 | How do cascading actions work with foreign key constraints, such as ON DELETE CASCADE, and what risks come with using them? SQL Server › Constraints (Primary Key, Foreign Key, Check & Unique) | SQL Server | Constraints (Primary Key, Foreign Key, Check & Unique) | Advanced |
| 49 | How would you build a centralized, reusable error logging procedure that captures detailed error information whenever it is called from within a CATCH block? SQL Server › Error Handling with TRY CATCH | SQL Server | Error Handling with TRY CATCH | Advanced |
| 50 | How do nested TRY CATCH blocks work, and when would you use them in a complex stored procedure? SQL Server › Error Handling with TRY CATCH | SQL Server | Error Handling with TRY CATCH | Advanced |
| 51 | How does Read Committed Snapshot Isolation differ from regular Read Committed isolation, and what tradeoff does enabling it introduce? SQL Server › Isolation & Locking | SQL Server | Isolation & Locking | Advanced |
| 52 | How would you design a stored procedure to handle a complex business process involving multiple steps, proper error handling, and transaction management together? SQL Server › Stored Procedures & Functions | SQL Server | Stored Procedures & Functions | Advanced |