Home › Interview Questions › Databases Sql Interview Questions

Databases Sql Interview Questions

1,479 real Databases Sql questions asked in live technical interviews — each with a model answer. Updated weekly.

🎤 Auto-captured by Assisting AI during live interviews

These Databases Sql interview questions were captured from real interviews by candidates using Assisting AI. Each links to a full model answer. For real-time help during your own interview, get Assisting AI from ₹500/day.

How would you troubleshoot a problem involving denormalization?🟡 Medium · Debugging · Asked 1×What are common mistakes engineers make when using schema versioning?🟡 Medium · Conceptual · Asked 1×How does MySQL affect reliability or scalability?🟡 Medium · Conceptual · Asked 1×What are common mistakes engineers make when using Oracle Database?🟡 Medium · Conceptual · Asked 1×How would you test a component that depends on query optimization?🟡 Medium · Conceptual · Asked 1×How would you explain the trade-off between correctness and performance when using materialized?🟢 Easy · Conceptual · Asked 1×Describe a realistic interview scenario where PostgreSQL would be useful.🟡 Medium · Conceptual · Asked 1×How would you design for failure recovery around EXPLAIN?🔴 Hard · System Design · Asked 1×How would you design for failure recovery around ANALYZE?🔴 Hard · System Design · Asked 1×How would you monitor and alert on failures involving planner?🟡 Medium · Conceptual · Asked 1×How does read compare with a common alternative?🟡 Medium · Conceptual · Asked 1×How would you monitor and alert on failures involving execution?🟡 Medium · Conceptual · Asked 1×What benefits and trade-offs come with isolation?🟡 Medium · Conceptual · Asked 1×How would you compare unique constraints and composite indexes for a production system?🔴 Hard · Conceptual · Asked 1×How would you compare covering indexes and B-tree indexes for a production system?🔴 Hard · Conceptual · Asked 1×How does ACID properties affect reliability or scalability?🟡 Medium · Conceptual · Asked 1×How would you compare schema versioning and stored procedures for a production system?🔴 Hard · Conceptual · Asked 1×What are common mistakes engineers make when using materialized views?🟡 Medium · Conceptual · Asked 1×When is isolation a poor choice for a production system?🟡 Medium · Conceptual · Asked 1×How would you document a production design that uses constraints?🟡 Medium · Behavioral · Asked 1×What metrics would you monitor for denormalization?🟡 Medium · Conceptual · Asked 1×What would you inspect first when denormalization is slow or unstable?🟡 Medium · Debugging · Asked 1×When would you use query, and when would you choose an alternative?🟡 Medium · Conceptual · Asked 1×What security considerations apply to query?🔴 Hard · Conceptual · Asked 1×Explain the role of planner in production systems.🟢 Easy · Conceptual · Asked 1×Explain the role of vacuum in production systems.🟢 Easy · Conceptual · Asked 1×How would you design for failure recovery around replicas?🔴 Hard · System Design · Asked 1×What follow-up could reveal whether a candidate really understands joins?🟡 Medium · Conceptual · Asked 1×What would you inspect first when CTE is slow or unstable?🟡 Medium · Debugging · Asked 1×What are common mistakes when using recursive?🟡 Medium · Debugging · Asked 1×Which configuration choices matter most for recursive?🟡 Medium · Conceptual · Asked 1×How is execution typically used in a real system?🟡 Medium · Conceptual · Asked 1×How would you test a production implementation that uses isolation?🟡 Medium · Other · Asked 1×What is sharding, and what problem does it solve?🟢 Easy · Conceptual · Asked 1×How would you test a component that depends on triggers?🟡 Medium · Conceptual · Asked 1×What is the difference between MariaDB and SQL Server, and when would you use each?🟢 Easy · Conceptual · Asked 1×How would you test a component that depends on Oracle Database?🟡 Medium · Conceptual · Asked 1×How does Elasticsearch affect reliability or scalability?🟡 Medium · Conceptual · Asked 1×What is the difference between DynamoDB and Cassandra, and when would you use each?🟢 Easy · Conceptual · Asked 1×What is the difference between BigQuery and Redshift, and when would you use each?🟢 Easy · Conceptual · Asked 1×How would you test a component that depends on SQL injection?🟡 Medium · Conceptual · Asked 1×What are the main trade-offs of using foreign keys?🟡 Medium · Conceptual · Asked 1×What are common mistakes engineers make when using SQL joins?🟡 Medium · Conceptual · Asked 1×When would you choose inner joins in a real project?🟡 Medium · Conceptual · Asked 1×How can you improve the performance of a system that uses left joins?🟡 Medium · Conceptual · Asked 1×When would you choose subqueries in a real project?🟡 Medium · Conceptual · Asked 1×What are common mistakes engineers make when using isolation levels?🟡 Medium · Conceptual · Asked 1×What follow-up could reveal whether a candidate really understands plans?🟡 Medium · Conceptual · Asked 1×How would you design for failure recovery around levels?🔴 Hard · System Design · Asked 1×How would you monitor and alert on failures involving levels?🟡 Medium · Conceptual · Asked 1×How should a system using materialized be designed for high load or concurrency?🔴 Hard · System Design · Asked 1×How would you monitor and alert on failures involving partitioning?🟡 Medium · Conceptual · Asked 1×How would you explain the trade-off between correctness and performance when using functions?🟢 Easy · Conceptual · Asked 1×Which configuration choices matter most for CTE?🟡 Medium · Conceptual · Asked 1×How should a system using recursive be designed for high load or concurrency?🔴 Hard · System Design · Asked 1×How would you implement or configure subqueries in a production environment?🟡 Medium · Coding · Asked 1×How would you explain the trade-off between correctness and performance when using indexes?🟢 Easy · Conceptual · Asked 1×What edge cases should an interviewer ask about for normalization?🟡 Medium · Conceptual · Asked 1×When is denormalization a poor choice for a production system?🟡 Medium · Conceptual · Asked 1×How would you test a production implementation that uses materialized?🟡 Medium · Other · Asked 1×Explain the role of MySQL in production systems.🟢 Easy · Conceptual · Asked 1×How is PostgreSQL typically used in a real system?🟡 Medium · Conceptual · Asked 1×When would you use EXPLAIN, and when would you choose an alternative?🟢 Easy · Conceptual · Asked 1×What is the difference between B-tree indexes and hash indexes, and when would you use each?🟢 Easy · Conceptual · Asked 1×How would you test a component that depends on GROUP BY?🟡 Medium · Conceptual · Asked 1×What are the main trade-offs of using transactions?🟡 Medium · Conceptual · Asked 1×How does MariaDB work at a high level?🟡 Medium · Conceptual · Asked 1×How does Oracle Database affect reliability or scalability?🟡 Medium · Conceptual · Asked 1×How can you improve the performance of a system that uses DynamoDB?🟡 Medium · Conceptual · Asked 1×What benefits and trade-offs come with transactions?🟡 Medium · Conceptual · Asked 1×How would you optimize a system that depends on transactions?🟡 Medium · System Design · Asked 1×How would you implement or configure isolation in a production environment?🟡 Medium · Coding · Asked 1×Explain the role of B-tree in production systems.🟢 Easy · Conceptual · Asked 1×How would you troubleshoot a problem involving B-tree?🟡 Medium · Debugging · Asked 1×Which configuration choices matter most for ANALYZE?🟡 Medium · Conceptual · Asked 1×How would you optimize a system that depends on analyze?🟡 Medium · System Design · Asked 1×How would you design for failure recovery around analyze?🔴 Hard · System Design · Asked 1×What would you inspect first when partitioning is slow or unstable?🟡 Medium · Debugging · Asked 1×What are common mistakes engineers make when using connection pooling?🟡 Medium · Conceptual · Asked 1×What is Cassandra, and what problem does it solve?🟢 Easy · Conceptual · Asked 1×How would you test a component that depends on covering indexes?🟡 Medium · Conceptual · Asked 1×How does subqueries affect reliability or scalability?🟡 Medium · Conceptual · Asked 1×When would you choose transactions in a real project?🟡 Medium · Conceptual · Asked 1×What are common mistakes engineers make when using optimistic locking?🟡 Medium · Conceptual · Asked 1×What are common mistakes when using joins?🟡 Medium · Debugging · Asked 1×What would you inspect first when window is slow or unstable?🟡 Medium · Debugging · Asked 1×How would you explain the trade-off between correctness and performance when using isolation?🟢 Easy · Conceptual · Asked 1×When would you use materialized, and when would you choose an alternative?🟡 Medium · Conceptual · Asked 1×How would you troubleshoot a problem involving planner?🟡 Medium · Debugging · Asked 1×How would you optimize a system that depends on vacuum?🟡 Medium · System Design · Asked 1×How would you design for failure recovery around vacuum?🔴 Hard · System Design · Asked 1×What benefits and trade-offs come with replication?🟡 Medium · Conceptual · Asked 1×How would you implement or configure read in a production environment?🟡 Medium · Coding · Asked 1×What follow-up could reveal whether a candidate really understands read?🟡 Medium · Conceptual · Asked 1×What are common mistakes when using replicas?🟡 Medium · Debugging · Asked 1×What is unique constraints, and what problem does it solve?🟢 Easy · Conceptual · Asked 1×What are the main trade-offs of using composite indexes?🟡 Medium · Conceptual · Asked 1×What is EXPLAIN, and what problem does it solve?🟢 Easy · Conceptual · Asked 1×What is the difference between SQL joins and inner joins, and when would you use each?🟢 Easy · Conceptual · Asked 1×How does self joins work at a high level?🟡 Medium · Conceptual · Asked 1×How would you test a component that depends on self joins?🟡 Medium · Conceptual · Asked 1×When would you choose GROUP BY in a real project?🟡 Medium · Conceptual · Asked 1×What are the main trade-offs of using isolation levels?🟡 Medium · Conceptual · Asked 1×How would you test a component that depends on replication?🟡 Medium · Conceptual · Asked 1×What are the main trade-offs of using database migrations?🟡 Medium · Conceptual · Asked 1×When would you choose triggers in a real project?🟡 Medium · Conceptual · Asked 1×What is the difference between views and materialized views, and when would you use each?🟢 Easy · Conceptual · Asked 1×What is MariaDB, and what problem does it solve?🟢 Easy · Conceptual · Asked 1×How can you improve the performance of a system that uses composite indexes?🟡 Medium · Conceptual · Asked 1×How can you improve the performance of a system that uses covering indexes?🟡 Medium · Conceptual · Asked 1×What is the difference between EXPLAIN and query optimization, and when would you use each?🟢 Easy · Conceptual · Asked 1×How would you compare inner joins and left joins for a production system?🔴 Hard · Conceptual · Asked 1×What is locks, and what problem does it solve?🟢 Easy · Conceptual · Asked 1×When would you use connection, and when would you choose an alternative?🟡 Medium · Conceptual · Asked 1×Why is the use of joins important in production?🟢 Easy · Conceptual · Asked 1×How would you explain the trade-off between correctness and performance when using subqueries?🟢 Easy · Conceptual · Asked 1×How would you migrate an existing system to subqueries safely?🔴 Hard · System Design · Asked 1×When is indexes a poor choice for a production system?🟡 Medium · Conceptual · Asked 1×Why is the use of execution important in production?🟢 Easy · Conceptual · Asked 1×How does execution compare with a common alternative?🟡 Medium · Conceptual · Asked 1×What would you inspect first when execution is slow or unstable?🟡 Medium · Debugging · Asked 1×When would you use plans, and when would you choose an alternative?🟡 Medium · Conceptual · Asked 1×How should a system using denormalization be designed for high load or concurrency?🔴 Hard · System Design · Asked 1×How would you migrate an existing system to materialized safely?🔴 Hard · System Design · Asked 1×How would you monitor and alert on failures involving EXPLAIN?🟢 Easy · Conceptual · Asked 1×How would you design for failure recovery around planner?🔴 Hard · System Design · Asked 1×How would you implement or configure partitioning in a production environment?🟡 Medium · Coding · Asked 1×How does replication compare with a common alternative?🟡 Medium · Conceptual · Asked 1×How is replicas typically used in a real system?🟡 Medium · Conceptual · Asked 1×What benefits and trade-offs come with replicas?🟡 Medium · Conceptual · Asked 1×What is normalization, and what problem does it solve?🟢 Easy · Conceptual · Asked 1×When would you choose materialized views in a real project?🟡 Medium · Conceptual · Asked 1×How does SQL Server affect reliability or scalability?🟡 Medium · Conceptual · Asked 1×How would you compare Redshift and SQL injection for a production system?🔴 Hard · Conceptual · Asked 1×When would you choose self joins in a real project?🟡 Medium · Conceptual · Asked 1×How would you compare locks and optimistic locking for a production system?🔴 Hard · Conceptual · Asked 1×What would you inspect first when connection is slow or unstable?🟡 Medium · Debugging · Asked 1×When would you use normalization, and when would you choose an alternative?🟡 Medium · Conceptual · Asked 1×What would you inspect first when normalization is slow or unstable?🟡 Medium · Debugging · Asked 1×How would you test a production implementation that uses denormalization?🟡 Medium · Other · Asked 1×How is materialized typically used in a real system?🟡 Medium · Conceptual · Asked 1×How should a system using PostgreSQL be designed for high load or concurrency?🔴 Hard · System Design · Asked 1×How would you design for failure recovery around PostgreSQL?🔴 Hard · System Design · Asked 1×What are common mistakes when using MVCC?🟡 Medium · Debugging · Asked 1×How would you implement or configure MVCC in a production environment?🟡 Medium · Coding · Asked 1×How would you test a production implementation that uses ANALYZE?🟡 Medium · Other · Asked 1×How should a system using replication be designed for high load or concurrency?🔴 Hard · System Design · Asked 1×What edge cases should an interviewer ask about for window?🟡 Medium · Conceptual · Asked 1×How would you optimize a system that depends on CTE?🟡 Medium · System Design · Asked 1×When is recursive a poor choice for a production system?🟡 Medium · Conceptual · Asked 1×When would you choose B-tree indexes in a real project?🟡 Medium · Conceptual · Asked 1×How would you compare anti joins and self joins for a production system?🔴 Hard · Conceptual · Asked 1×What are the main trade-offs of using CTEs?🟡 Medium · Conceptual · Asked 1×What are common mistakes engineers make when using MVCC?🟡 Medium · Conceptual · Asked 1×How can you improve the performance of a system that uses partitioning?🟡 Medium · Conceptual · Asked 1×How would you compare failover and connection pooling for a production system?🔴 Hard · Conceptual · Asked 1×How would you compare materialized views and MySQL for a production system?🔴 Hard · Conceptual · Asked 1×What is Snowflake, and what problem does it solve?🟢 Easy · Conceptual · Asked 1×How would you monitor and alert on failures involving isolation?🟡 Medium · Conceptual · Asked 1×How does denormalization compare with a common alternative?🟡 Medium · Conceptual · Asked 1×What edge cases should an interviewer ask about for MySQL?🟡 Medium · Conceptual · Asked 1×How does PostgreSQL compare with a common alternative?🟡 Medium · Conceptual · Asked 1×How is planner typically used in a real system?🟡 Medium · Conceptual · Asked 1×What metrics would you monitor for partitioning?🟡 Medium · Conceptual · Asked 1×What metrics would you monitor for read?🟡 Medium · Conceptual · Asked 1×What metrics would you monitor for replicas?🟡 Medium · Conceptual · Asked 1×What would you inspect first when functions is slow or unstable?🟡 Medium · Debugging · Asked 1×When would you use CTE, and when would you choose an alternative?🟡 Medium · Conceptual · Asked 1×Explain the role of subqueries in production systems.🟢 Easy · Conceptual · Asked 1×How would you design for failure recovery around subqueries?🔴 Hard · System Design · Asked 1×How would you monitor and alert on failures involving subqueries?🟡 Medium · Conceptual · Asked 1×When is pooling a poor choice for a production system?🟡 Medium · Conceptual · Asked 1×How does partitioning affect reliability or scalability?🟡 Medium · Conceptual · Asked 1×How does schema versioning work at a high level?🟡 Medium · Conceptual · Asked 1×When would you choose Redshift in a real project?🟡 Medium · Conceptual · Asked 1×What are common mistakes engineers make when using anti joins?🟡 Medium · Conceptual · Asked 1×What is window functions, and what problem does it solve?🟢 Easy · Conceptual · Asked 1×What is the difference between GROUP BY and HAVING, and when would you use each?🟢 Easy · Conceptual · Asked 1×What metrics would you monitor for connection?🟡 Medium · Conceptual · Asked 1×How would you test a production implementation that uses pooling?🟡 Medium · Other · Asked 1×Why is the use of window important in production?🟢 Easy · Conceptual · Asked 1×How would you monitor and alert on failures involving CTE?🟡 Medium · Conceptual · Asked 1×How would you implement or configure indexes in a production environment?🟡 Medium · Coding · Asked 1×Explain the role of levels in production systems.🟢 Easy · Conceptual · Asked 1×Why is the use of PostgreSQL important in production?🟢 Easy · Conceptual · Asked 1×Describe a realistic interview scenario where EXPLAIN would be useful.🟢 Easy · Conceptual · Asked 1×How would you document a production design that uses EXPLAIN?🟢 Easy · Behavioral · Asked 1×How would you migrate an existing system to replication safely?🔴 Hard · System Design · Asked 1×Which configuration choices matter most for logical?🟡 Medium · Conceptual · Asked 1×What are common mistakes when using read?🟡 Medium · Debugging · Asked 1×How would you monitor and alert on failures involving joins?🟡 Medium · Conceptual · Asked 1×How would you optimize a system that depends on functions?🟡 Medium · System Design · Asked 1×How would you migrate an existing system to functions safely?🔴 Hard · System Design · Asked 1×Why is the use of CTE important in production?🟢 Easy · Conceptual · Asked 1×How is CTE typically used in a real system?🟡 Medium · Conceptual · Asked 1×How does CTE compare with a common alternative?🟡 Medium · Conceptual · Asked 1×How does indexes compare with a common alternative?🟡 Medium · Conceptual · Asked 1×Why is the use of plans important in production?🟢 Easy · Conceptual · Asked 1×Describe a realistic interview scenario where transactions would be useful.🟡 Medium · Conceptual · Asked 1×When would you use isolation, and when would you choose an alternative?🟡 Medium · Conceptual · Asked 1×When would you use constraints, and when would you choose an alternative?🟡 Medium · Conceptual · Asked 1×When would you use MVCC, and when would you choose an alternative?🟡 Medium · Conceptual · Asked 1×How would you monitor and alert on failures involving MVCC?🟡 Medium · Conceptual · Asked 1×How would you document a production design that uses ANALYZE?🟡 Medium · Behavioral · Asked 1×What edge cases should an interviewer ask about for analyze?🟡 Medium · Conceptual · Asked 1×How would you test a production implementation that uses read?🟡 Medium · Other · Asked 1×How would you troubleshoot a problem involving composite indexes?🟡 Medium · Debugging · Asked 1×When would you choose query execution plans in a real project?🟡 Medium · Conceptual · Asked 1×What are the main trade-offs of using SQL joins?🟡 Medium · Conceptual · Asked 1×What are the main trade-offs of using self joins?🟡 Medium · Conceptual · Asked 1×How would you test a component that depends on MVCC?🟡 Medium · Conceptual · Asked 1×How would you compare denormalization and partitioning for a production system?🔴 Hard · Conceptual · Asked 1×What is the difference between partitioning and sharding, and when would you use each?🟢 Easy · Conceptual · Asked 1×How does PostgreSQL affect reliability or scalability?🟡 Medium · Conceptual · Asked 1×How can you improve the performance of a system that uses Redis?🟡 Medium · Conceptual · Asked 1×How does DynamoDB affect reliability or scalability?🟡 Medium · Conceptual · Asked 1×What follow-up could reveal whether a candidate really understands replicas?🟡 Medium · Conceptual · Asked 1×Which configuration choices matter most for connection?🟡 Medium · Conceptual · Asked 1×How would you explain the trade-off between correctness and performance when using pooling?🟢 Easy · Conceptual · Asked 1×How would you implement or configure recursive in a production environment?🟡 Medium · Coding · Asked 1×Describe a realistic interview scenario where recursive would be useful.🟡 Medium · Conceptual · Asked 1×Explain the role of execution in production systems.🟢 Easy · Conceptual · Asked 1×How would you optimize a system that depends on execution?🟡 Medium · System Design · Asked 1×What are common mistakes when using plans?🟡 Medium · Debugging · Asked 1×Why is the use of transactions important in production?🟢 Easy · Conceptual · Asked 1×How would you troubleshoot a problem involving isolation?🟡 Medium · Debugging · Asked 1×How should a system using isolation be designed for high load or concurrency?🔴 Hard · System Design · Asked 1×What are common mistakes when using levels?🟡 Medium · Debugging · Asked 1×What security considerations apply to denormalization?🔴 Hard · Conceptual · Asked 1×How should a system using MySQL be designed for high load or concurrency?🔴 Hard · System Design · Asked 1×How would you design for failure recovery around B-tree?🔴 Hard · System Design · Asked 1×What are common mistakes when using ANALYZE?🟡 Medium · Debugging · Asked 1×How would you explain the trade-off between correctness and performance when using planner?🟢 Easy · Conceptual · Asked 1×How should a system using logical be designed for high load or concurrency?🔴 Hard · System Design · Asked 1×When is logical a poor choice for a production system?🟡 Medium · Conceptual · Asked 1×How would you migrate an existing system to read safely?🔴 Hard · System Design · Asked 1×How would you monitor and alert on failures involving read?🟡 Medium · Conceptual · Asked 1×What is partitioning, and what problem does it solve?🟢 Easy · Conceptual · Asked 1×What are common mistakes engineers make when using replication?🟡 Medium · Conceptual · Asked 1×How does MariaDB affect reliability or scalability?🟡 Medium · Conceptual · Asked 1×How would you troubleshoot a problem involving DynamoDB?🟡 Medium · Debugging · Asked 1×When would you choose Cassandra in a real project?🟡 Medium · Conceptual · Asked 1×How does hash indexes affect reliability or scalability?🟡 Medium · Conceptual · Asked 1×What is the difference between inner joins and left joins, and when would you use each?🟢 Easy · Conceptual · Asked 1×How can you improve the performance of a system that uses subqueries?🟡 Medium · Conceptual · Asked 1×What is isolation levels, and what problem does it solve?🟢 Easy · Conceptual · Asked 1×How does joins compare with a common alternative?🟡 Medium · Conceptual · Asked 1×How is functions typically used in a real system?🟡 Medium · Conceptual · Asked 1×Explain the role of recursive in production systems.🟢 Easy · Conceptual · Asked 1×Why is the use of recursive important in production?🟢 Easy · Conceptual · Asked 1×What are common mistakes when using subqueries?🟡 Medium · Debugging · Asked 1×How would you document a production design that uses subqueries?🟡 Medium · Behavioral · Asked 1×How would you explain the trade-off between correctness and performance when using plans?🟢 Easy · Conceptual · Asked 1×Why is the use of levels important in production?🟢 Easy · Conceptual · Asked 1×How would you design for failure recovery around constraints?🔴 Hard · System Design · Asked 1×How would you optimize a system that depends on denormalization?🟡 Medium · System Design · Asked 1×How would you explain the trade-off between correctness and performance when using MySQL?🟢 Easy · Conceptual · Asked 1×What are common mistakes when using EXPLAIN?🟢 Easy · Debugging · Asked 1×How would you test a production implementation that uses vacuum?🟡 Medium · Other · Asked 1×What metrics would you monitor for vacuum?🟡 Medium · Conceptual · Asked 1×How would you design for failure recovery around replication?🔴 Hard · System Design · Asked 1×What are the main trade-offs of using relational databases?🟡 Medium · Conceptual · Asked 1×How would you troubleshoot a problem involving primary keys?🟡 Medium · Debugging · Asked 1×How would you compare SQL joins and inner joins for a production system?🔴 Hard · Conceptual · Asked 1×How does inner joins affect reliability or scalability?🟡 Medium · Conceptual · Asked 1×What is left joins, and what problem does it solve?🟢 Easy · Conceptual · Asked 1×What is the difference between ACID properties and isolation levels, and when would you use each?🟢 Easy · Conceptual · Asked 1×How would you compare ACID properties and isolation levels for a production system?🔴 Hard · Conceptual · Asked 1×What are the main trade-offs of using locks?🟡 Medium · Conceptual · Asked 1×When would you choose optimistic locking in a real project?🟡 Medium · Conceptual · Asked 1×How can you improve the performance of a system that uses Oracle Database?🟡 Medium · Conceptual · Asked 1×How does BigQuery affect reliability or scalability?🟡 Medium · Conceptual · Asked 1×How would you troubleshoot a problem involving SQL injection?🟡 Medium · Debugging · Asked 1×When would you choose MySQL in a real project?🟡 Medium · Conceptual · Asked 1×What are the main trade-offs of using MongoDB?🟡 Medium · Conceptual · Asked 1×What are the main trade-offs of using Elasticsearch?🟡 Medium · Conceptual · Asked 1×What are common mistakes engineers make when using primary keys?🟡 Medium · Conceptual · Asked 1×How can you improve the performance of a system that uses B-tree indexes?🟡 Medium · Conceptual · Asked 1×When would you choose EXPLAIN in a real project?🟡 Medium · Conceptual · Asked 1×How does query optimization work at a high level?🟡 Medium · Conceptual · Asked 1×How would you troubleshoot a problem involving query optimization?🟡 Medium · Debugging · Asked 1×What is the difference between self joins and subqueries, and when would you use each?🟢 Easy · Conceptual · Asked 1×How would you compare CTEs and recursive CTEs for a production system?🔴 Hard · Conceptual · Asked 1×How does GROUP BY work at a high level?🟡 Medium · Conceptual · Asked 1×How would you monitor and alert on failures involving replicas?🟡 Medium · Conceptual · Asked 1×Describe a realistic interview scenario where connection would be useful.🟡 Medium · Conceptual · Asked 1×How would you explain the trade-off between correctness and performance when using joins?🟢 Easy · Conceptual · Asked 1×How would you document a production design that uses functions?🟡 Medium · Behavioral · Asked 1×When is CTE a poor choice for a production system?🟡 Medium · Conceptual · Asked 1×When is subqueries a poor choice for a production system?🟡 Medium · Conceptual · Asked 1×How should a system using plans be designed for high load or concurrency?🔴 Hard · System Design · Asked 1×How would you implement or configure transactions in a production environment?🟡 Medium · Coding · Asked 1×How would you optimize a system that depends on isolation?🟡 Medium · System Design · Asked 1×What would you inspect first when constraints is slow or unstable?🟡 Medium · Debugging · Asked 1×How is views typically used in a real system?🟡 Medium · Conceptual · Asked 1×Describe a realistic interview scenario where MVCC would be useful.🟡 Medium · Conceptual · Asked 1×When would you use B-tree, and when would you choose an alternative?🟡 Medium · Conceptual · Asked 1×What metrics would you monitor for ANALYZE?🟡 Medium · Conceptual · Asked 1×Describe a realistic interview scenario where query would be useful.🟡 Medium · Conceptual · Asked 1×What edge cases should an interviewer ask about for vacuum?🟡 Medium · Conceptual · Asked 1×What benefits and trade-offs come with partitioning?🟡 Medium · Conceptual · Asked 1×When is replication a poor choice for a production system?🟡 Medium · Conceptual · Asked 1×How would you monitor and alert on failures involving replication?🟡 Medium · Conceptual · Asked 1×How would you design for failure recovery around read?🔴 Hard · System Design · Asked 1×How does normalization work at a high level?🟡 Medium · Conceptual · Asked 1×How would you compare normalization and denormalization for a production system?🔴 Hard · Conceptual · Asked 1×How would you test a component that depends on read replicas?🟡 Medium · Conceptual · Asked 1×How does PostgreSQL work at a high level?🟡 Medium · Conceptual · Asked 1×What is SQLite, and what problem does it solve?🟢 Easy · Conceptual · Asked 1×What is Elasticsearch, and what problem does it solve?🟢 Easy · Conceptual · Asked 1×How can you improve the performance of a system that uses Elasticsearch?🟡 Medium · Conceptual · Asked 1×What are common mistakes engineers make when using relational databases?🟡 Medium · Conceptual · Asked 1×How would you test a component that depends on B-tree indexes?🟡 Medium · Conceptual · Asked 1×How would you compare EXPLAIN and query optimization for a production system?🔴 Hard · Conceptual · Asked 1×How would you test a component that depends on SQL joins?🟡 Medium · Conceptual · Asked 1×How would you troubleshoot a problem involving left joins?🟡 Medium · Debugging · Asked 1×Explain the role of connection in production systems.🟢 Easy · Conceptual · Asked 1×How is pooling typically used in a real system?🟡 Medium · Conceptual · Asked 1×What metrics would you monitor for pooling?🟡 Medium · Conceptual · Asked 1×How would you test a production implementation that uses B-tree?🟡 Medium · Other · Asked 1×What benefits and trade-offs come with planner?🟡 Medium · Conceptual · Asked 1×How does window compare with a common alternative?🟡 Medium · Conceptual · Asked 1×Why is the use of functions important in production?🟢 Easy · Conceptual · Asked 1×How does transactions compare with a common alternative?🟡 Medium · Conceptual · Asked 1×What metrics would you monitor for isolation?🟡 Medium · Conceptual · Asked 1×What are the main trade-offs of using covering indexes?🟡 Medium · Conceptual · Asked 1×What is the difference between covering indexes and B-tree indexes, and when would you use each?🟢 Easy · Conceptual · Asked 1×What is B-tree indexes, and what problem does it solve?🟢 Easy · Conceptual · Asked 1×What is GROUP BY, and what problem does it solve?🟢 Easy · Conceptual · Asked 1×How does sharding affect reliability or scalability?🟡 Medium · Conceptual · Asked 1×How would you test a component that depends on schema versioning?🟡 Medium · Conceptual · Asked 1×How would you troubleshoot a problem involving triggers?🟡 Medium · Debugging · Asked 1×How can you improve the performance of a system that uses PostgreSQL?🟡 Medium · Conceptual · Asked 1×How does Cassandra affect reliability or scalability?🟡 Medium · Conceptual · Asked 1×How would you compare BigQuery and Redshift for a production system?🔴 Hard · Conceptual · Asked 1×When would you choose SQL injection in a real project?🟡 Medium · Conceptual · Asked 1×How does constraints compare with a common alternative?🟡 Medium · Conceptual · Asked 1×Which configuration choices matter most for constraints?🟡 Medium · Conceptual · Asked 1×What benefits and trade-offs come with normalization?🟡 Medium · Conceptual · Asked 1×Describe a realistic interview scenario where normalization would be useful.🟡 Medium · Conceptual · Asked 1×What benefits and trade-offs come with MySQL?🟡 Medium · Conceptual · Asked 1×What edge cases should an interviewer ask about for PostgreSQL?🟡 Medium · Conceptual · Asked 1×When is B-tree a poor choice for a production system?🟡 Medium · Conceptual · Asked 1×How is query typically used in a real system?🟡 Medium · Conceptual · Asked 1×How would you explain the trade-off between correctness and performance when using query?🟢 Easy · Conceptual · Asked 1×What edge cases should an interviewer ask about for replication?🟡 Medium · Conceptual · Asked 1×What benefits and trade-offs come with functions?🟡 Medium · Conceptual · Asked 1×How would you design for failure recovery around plans?🔴 Hard · System Design · Asked 1×How would you document a production design that uses connection?🟡 Medium · Behavioral · Asked 1×Why is the use of pooling important in production?🟢 Easy · Conceptual · Asked 1×How would you troubleshoot a problem involving pessimistic locking?🟡 Medium · Debugging · Asked 1×What is the difference between pessimistic locking and normalization, and when would you use each?🟢 Easy · Conceptual · Asked 1×How would you compare pessimistic locking and normalization for a production system?🔴 Hard · Conceptual · Asked 1×How would you compare partitioning and sharding for a production system?🔴 Hard · Conceptual · Asked 1×What is failover, and what problem does it solve?🟢 Easy · Conceptual · Asked 1×When would you choose schema versioning in a real project?🟡 Medium · Conceptual · Asked 1×How does triggers affect reliability or scalability?🟡 Medium · Conceptual · Asked 1×How can you improve the performance of a system that uses unique constraints?🟡 Medium · Conceptual · Asked 1×What is the difference between composite indexes and covering indexes, and when would you use each?🟢 Easy · Conceptual · Asked 1×What are common mistakes engineers make when using HAVING?🟡 Medium · Conceptual · Asked 1×What is the difference between isolation levels and MVCC, and when would you use each?🟢 Easy · Conceptual · Asked 1×What edge cases should an interviewer ask about for functions?🟡 Medium · Conceptual · Asked 1×What edge cases should an interviewer ask about for subqueries?🟡 Medium · Conceptual · Asked 1×How would you test a production implementation that uses indexes?🟡 Medium · Other · Asked 1×What security considerations apply to indexes?🔴 Hard · Conceptual · Asked 1×How should a system using levels be designed for high load or concurrency?🔴 Hard · System Design · Asked 1×How would you explain the trade-off between correctness and performance when using views?🟢 Easy · Conceptual · Asked 1×Explain the role of PostgreSQL in production systems.🟢 Easy · Conceptual · Asked 1×How would you explain the trade-off between correctness and performance when using PostgreSQL?🟢 Easy · Conceptual · Asked 1×Why is the use of ANALYZE important in production?🟢 Easy · Conceptual · Asked 1×What follow-up could reveal whether a candidate really understands analyze?🟡 Medium · Conceptual · Asked 1×What would you inspect first when replication is slow or unstable?🟡 Medium · Debugging · Asked 1×What metrics would you monitor for logical?🟡 Medium · Conceptual · Asked 1×How would you explain the trade-off between correctness and performance when using logical?🟢 Easy · Conceptual · Asked 1×What security considerations apply to read?🔴 Hard · Conceptual · Asked 1×How should a system using replicas be designed for high load or concurrency?🔴 Hard · System Design · Asked 1×How would you design for failure recovery around joins?🔴 Hard · System Design · Asked 1×How should a system using window be designed for high load or concurrency?🔴 Hard · System Design · Asked 1×What follow-up could reveal whether a candidate really understands functions?🟡 Medium · Conceptual · Asked 1×How would you test a production implementation that uses CTE?🟡 Medium · Other · Asked 1×How would you document a production design that uses recursive?🟡 Medium · Behavioral · Asked 1×Why is the use of subqueries important in production?🟢 Easy · Conceptual · Asked 1×What security considerations apply to subqueries?🔴 Hard · Conceptual · Asked 1×What would you inspect first when plans is slow or unstable?🟡 Medium · Debugging · Asked 1×Explain the role of views in production systems.🟢 Easy · Conceptual · Asked 1×How does materialized compare with a common alternative?🟡 Medium · Conceptual · Asked 1×What security considerations apply to PostgreSQL?🔴 Hard · Conceptual · Asked 1×What metrics would you monitor for PostgreSQL?🟡 Medium · Conceptual · Asked 1×Describe a realistic interview scenario where ANALYZE would be useful.🟡 Medium · Conceptual · Asked 1×How would you test a production implementation that uses query?🟡 Medium · Other · Asked 1×Which configuration choices matter most for analyze?🟡 Medium · Conceptual · Asked 1×How would you monitor and alert on failures involving analyze?🟡 Medium · Conceptual · Asked 1×How does logical compare with a common alternative?🟡 Medium · Conceptual · Asked 1×How does composite indexes work at a high level?🟡 Medium · Conceptual · Asked 1×How can you improve the performance of a system that uses SQLite?🟡 Medium · Conceptual · Asked 1×When would you choose Elasticsearch in a real project?🟡 Medium · Conceptual · Asked 1×How can you improve the performance of a system that uses Snowflake?🟡 Medium · Conceptual · Asked 1×How does Redshift work at a high level?🟡 Medium · Conceptual · Asked 1×What edge cases should an interviewer ask about for pooling?🟡 Medium · Conceptual · Asked 1×What security considerations apply to pooling?🔴 Hard · Conceptual · Asked 1×Which configuration choices matter most for joins?🟡 Medium · Conceptual · Asked 1×Describe a realistic interview scenario where subqueries would be useful.🟡 Medium · Conceptual · Asked 1×Explain the role of plans in production systems.🟢 Easy · Conceptual · Asked 1×Explain the role of isolation in production systems.🟢 Easy · Conceptual · Asked 1×How should a system using MVCC be designed for high load or concurrency?🔴 Hard · System Design · Asked 1×How does MVCC compare with a common alternative?🟡 Medium · Conceptual · Asked 1×What are common mistakes when using vacuum?🟡 Medium · Debugging · Asked 1×Why is the use of analyze important in production?🟢 Easy · Conceptual · Asked 1×How would you optimize a system that depends on partitioning?🟡 Medium · System Design · Asked 1×Describe a realistic interview scenario where replication would be useful.🟡 Medium · Conceptual · Asked 1×How would you optimize a system that depends on logical?🟡 Medium · System Design · Asked 1×What are common mistakes engineers make when using normalization?🟡 Medium · Conceptual · Asked 1×How would you test a component that depends on connection pooling?🟡 Medium · Conceptual · Asked 1×How would you test a component that depends on primary keys?🟡 Medium · Conceptual · Asked 1×How can you improve the performance of a system that uses EXPLAIN?🟡 Medium · Conceptual · Asked 1×What are common mistakes engineers make when using EXPLAIN?🟡 Medium · Conceptual · Asked 1×What are the main trade-offs of using left joins?🟡 Medium · Conceptual · Asked 1×What is self joins, and what problem does it solve?🟢 Easy · Conceptual · Asked 1×How would you compare deadlocks and locks for a production system?🔴 Hard · Conceptual · Asked 1×What benefits and trade-offs come with indexes?🟡 Medium · Conceptual · Asked 1×What would you inspect first when indexes is slow or unstable?🟡 Medium · Debugging · Asked 1×What edge cases should an interviewer ask about for constraints?🟡 Medium · Conceptual · Asked 1×What benefits and trade-offs come with denormalization?🟡 Medium · Conceptual · Asked 1×What are common mistakes when using denormalization?🟡 Medium · Debugging · Asked 1×What security considerations apply to views?🔴 Hard · Conceptual · Asked 1×What metrics would you monitor for views?🟡 Medium · Conceptual · Asked 1×When is views a poor choice for a production system?🟡 Medium · Conceptual · Asked 1×How would you optimize a system that depends on materialized?🟡 Medium · System Design · Asked 1×How would you migrate an existing system to MySQL safely?🔴 Hard · System Design · Asked 1×Explain the role of EXPLAIN in production systems.🟢 Easy · Conceptual · Asked 1×How is analyze typically used in a real system?🟡 Medium · Conceptual · Asked 1×What edge cases should an interviewer ask about for partitioning?🟡 Medium · Conceptual · Asked 1×How would you design for failure recovery around partitioning?🔴 Hard · System Design · Asked 1×What security considerations apply to replication?🔴 Hard · Conceptual · Asked 1×How would you optimize a system that depends on connection?🟡 Medium · System Design · Asked 1×When would you choose foreign keys in a real project?🟡 Medium · Conceptual · Asked 1×What are common mistakes engineers make when using locks?🟡 Medium · Conceptual · Asked 1×How would you troubleshoot a problem involving connection pooling?🟡 Medium · Debugging · Asked 1×What is database migrations, and what problem does it solve?🟢 Easy · Conceptual · Asked 1×How does stored procedures affect reliability or scalability?🟡 Medium · Conceptual · Asked 1×How does materialized views work at a high level?🟡 Medium · Conceptual · Asked 1×How does MySQL work at a high level?🟡 Medium · Conceptual · Asked 1×What is the difference between Cassandra and Snowflake, and when would you use each?🟢 Easy · Conceptual · Asked 1×How can you improve the performance of a system that uses read replicas?🟡 Medium · Conceptual · Asked 1×What are the main trade-offs of using connection pooling?🟡 Medium · Conceptual · Asked 1×How would you compare triggers and views for a production system?🔴 Hard · Conceptual · Asked 1×How would you test a component that depends on Redis?🟡 Medium · Conceptual · Asked 1×How would you test a component that depends on CTEs?🟡 Medium · Conceptual · Asked 1×What is ACID properties, and what problem does it solve?🟢 Easy · Conceptual · Asked 1×What are the main trade-offs of using optimistic locking?🟡 Medium · Conceptual · Asked 1×How would you compare optimistic locking and pessimistic locking for a production system?🔴 Hard · Conceptual · Asked 1×Which configuration choices matter most for pooling?🟡 Medium · Conceptual · Asked 1×Describe a realistic interview scenario where joins would be useful.🟡 Medium · Conceptual · Asked 1×How would you document a production design that uses joins?🟡 Medium · Behavioral · Asked 1×How is window typically used in a real system?🟡 Medium · Conceptual · Asked 1×How would you document a production design that uses window?🟡 Medium · Behavioral · Asked 1×What security considerations apply to functions?🔴 Hard · Conceptual · Asked 1×What would you inspect first when subqueries is slow or unstable?🟡 Medium · Debugging · Asked 1×How would you test a production implementation that uses transactions?🟡 Medium · Other · Asked 1×How would you migrate an existing system to isolation safely?🔴 Hard · System Design · Asked 1×How would you implement or configure denormalization in a production environment?🟡 Medium · Coding · Asked 1×Why is the use of query important in production?🟢 Easy · Conceptual · Asked 1×When is planner a poor choice for a production system?🟡 Medium · Conceptual · Asked 1×How would you test a component that depends on denormalization?🟡 Medium · Conceptual · Asked 1×How would you troubleshoot a problem involving partitioning?🟡 Medium · Debugging · Asked 1×What are the main trade-offs of using schema versioning?🟡 Medium · Conceptual · Asked 1×What are the main trade-offs of using PostgreSQL?🟡 Medium · Conceptual · Asked 1×How does SQLite work at a high level?🟡 Medium · Conceptual · Asked 1×How would you compare composite indexes and covering indexes for a production system?🔴 Hard · Conceptual · Asked 1×What is hash indexes, and what problem does it solve?🟢 Easy · Conceptual · Asked 1×What is the difference between anti joins and self joins, and when would you use each?🟢 Easy · Conceptual · Asked 1×How can you improve the performance of a system that uses recursive CTEs?🟡 Medium · Conceptual · Asked 1×When would you choose isolation levels in a real project?🟡 Medium · Conceptual · Asked 1×When would you choose locks in a real project?🟡 Medium · Conceptual · Asked 1×How would you test a production implementation that uses MVCC?🟡 Medium · Other · Asked 1×How would you document a production design that uses MVCC?🟡 Medium · Behavioral · Asked 1×What metrics would you monitor for B-tree?🟡 Medium · Conceptual · Asked 1×When would you use planner, and when would you choose an alternative?🟡 Medium · Conceptual · Asked 1×Why is the use of vacuum important in production?🟢 Easy · Conceptual · Asked 1×How would you test a production implementation that uses analyze?🟡 Medium · Other · Asked 1×How would you explain the trade-off between correctness and performance when using analyze?🟢 Easy · Conceptual · Asked 1×How would you test a production implementation that uses partitioning?🟡 Medium · Other · Asked 1×Why is the use of read important in production?🟢 Easy · Conceptual · Asked 1×What edge cases should an interviewer ask about for replicas?🟡 Medium · Conceptual · Asked 1×How would you design for failure recovery around CTE?🔴 Hard · System Design · Asked 1×What metrics would you monitor for plans?🟡 Medium · Conceptual · Asked 1×When would you choose relational databases in a real project?🟡 Medium · Conceptual · Asked 1×How does primary keys affect reliability or scalability?🟡 Medium · Conceptual · Asked 1×When would you choose left joins in a real project?🟡 Medium · Conceptual · Asked 1×How would you compare left joins and anti joins for a production system?🔴 Hard · Conceptual · Asked 1×How does self joins affect reliability or scalability?🟡 Medium · Conceptual · Asked 1×What are common mistakes engineers make when using recursive CTEs?🟡 Medium · Conceptual · Asked 1×What are the main trade-offs of using ACID properties?🟡 Medium · Conceptual · Asked 1×How does isolation levels work at a high level?🟡 Medium · Conceptual · Asked 1×How can you improve the performance of a system that uses locks?🟡 Medium · Conceptual · Asked 1×What are common mistakes engineers make when using sharding?🟡 Medium · Conceptual · Asked 1×How does replication affect reliability or scalability?🟡 Medium · Conceptual · Asked 1×What is the difference between read replicas and failover, and when would you use each?🟢 Easy · Conceptual · Asked 1×What are common mistakes engineers make when using failover?🟡 Medium · Conceptual · Asked 1×What is triggers, and what problem does it solve?🟢 Easy · Conceptual · Asked 1×What is the difference between MySQL and PostgreSQL, and when would you use each?🟢 Easy · Conceptual · Asked 1×How would you troubleshoot a problem involving Oracle Database?🟡 Medium · Debugging · Asked 1×How would you compare Snowflake and BigQuery for a production system?🔴 Hard · Conceptual · Asked 1×How can you improve the performance of a system that uses SQL injection?🟡 Medium · Conceptual · Asked 1×What follow-up could reveal whether a candidate really understands query?🟡 Medium · Conceptual · Asked 1×How would you migrate an existing system to vacuum safely?🔴 Hard · System Design · Asked 1×How should a system using analyze be designed for high load or concurrency?🔴 Hard · System Design · Asked 1×How does partitioning compare with a common alternative?🟡 Medium · Conceptual · Asked 1×What benefits and trade-offs come with read?🟡 Medium · Conceptual · Asked 1×How should a system using CTE be designed for high load or concurrency?🔴 Hard · System Design · Asked 1×How would you test a production implementation that uses plans?🟡 Medium · Other · Asked 1×What security considerations apply to transactions?🔴 Hard · Conceptual · Asked 1×How would you explain the trade-off between correctness and performance when using connection?🟢 Easy · Conceptual · Asked 1×How can you improve the performance of a system that uses denormalization?🟡 Medium · Conceptual · Asked 1×How would you compare connection pooling and database migrations for a production system?🔴 Hard · Conceptual · Asked 1×How would you troubleshoot a problem involving views?🟡 Medium · Debugging · Asked 1×How would you compare views and materialized views for a production system?🔴 Hard · Conceptual · Asked 1×How would you test a component that depends on MySQL?🟡 Medium · Conceptual · Asked 1×What is the difference between Oracle Database and SQLite, and when would you use each?🟢 Easy · Conceptual · Asked 1×How would you test a component that depends on DynamoDB?🟡 Medium · Conceptual · Asked 1×What is the difference between Snowflake and BigQuery, and when would you use each?🟢 Easy · Conceptual · Asked 1×What are common mistakes engineers make when using SQL injection?🟡 Medium · Conceptual · Asked 1×How does SQL injection affect reliability or scalability?🟡 Medium · Conceptual · Asked 1×How would you compare relational databases and primary keys for a production system?🔴 Hard · Conceptual · Asked 1×What is foreign keys, and what problem does it solve?🟢 Easy · Conceptual · Asked 1×How can you improve the performance of a system that uses hash indexes?🟡 Medium · Conceptual · Asked 1×What are common mistakes engineers make when using window functions?🟡 Medium · Conceptual · Asked 1×What are common mistakes engineers make when using deadlocks?🟡 Medium · Conceptual · Asked 1×What follow-up could reveal whether a candidate really understands CTE?🟡 Medium · Conceptual · Asked 1×How would you optimize a system that depends on subqueries?🟡 Medium · System Design · Asked 1×What edge cases should an interviewer ask about for isolation?🟡 Medium · Conceptual · Asked 1×When is levels a poor choice for a production system?🟡 Medium · Conceptual · Asked 1×What edge cases should an interviewer ask about for views?🟡 Medium · Conceptual · Asked 1×How would you implement or configure MySQL in a production environment?🟡 Medium · Coding · Asked 1×What would you inspect first when ANALYZE is slow or unstable?🟡 Medium · Debugging · Asked 1×How would you implement or configure analyze in a production environment?🟡 Medium · Coding · Asked 1×When is analyze a poor choice for a production system?🟡 Medium · Conceptual · Asked 1×What security considerations apply to replicas?🔴 Hard · Conceptual · Asked 1×Describe a realistic interview scenario where indexes would be useful.🟡 Medium · Conceptual · Asked 1×Which configuration choices matter most for transactions?🟡 Medium · Conceptual · Asked 1×How would you explain the trade-off between correctness and performance when using constraints?🟢 Easy · Conceptual · Asked 1×What edge cases should an interviewer ask about for materialized?🟡 Medium · Conceptual · Asked 1×Explain the role of MVCC in production systems.🟢 Easy · Conceptual · Asked 1×Describe a realistic interview scenario where B-tree would be useful.🟡 Medium · Conceptual · Asked 1×How would you test a production implementation that uses EXPLAIN?🟢 Easy · Other · Asked 1×When is query a poor choice for a production system?🟡 Medium · Conceptual · Asked 1×How would you implement or configure planner in a production environment?🟡 Medium · Coding · Asked 1×Explain the role of partitioning in production systems.🟢 Easy · Conceptual · Asked 1×When would you use replication, and when would you choose an alternative?🟡 Medium · Conceptual · Asked 1×When would you use read, and when would you choose an alternative?🟡 Medium · Conceptual · Asked 1×When would you choose composite indexes in a real project?🟡 Medium · Conceptual · Asked 1×How does covering indexes work at a high level?🟡 Medium · Conceptual · Asked 1×What are common mistakes engineers make when using B-tree indexes?🟡 Medium · Conceptual · Asked 1×What are common mistakes engineers make when using query optimization?🟡 Medium · Conceptual · Asked 1×How would you test a component that depends on optimistic locking?🟡 Medium · Conceptual · Asked 1×How does denormalization work at a high level?🟡 Medium · Conceptual · Asked 1×What is the difference between sharding and replication, and when would you use each?🟢 Easy · Conceptual · Asked 1×How can you improve the performance of a system that uses schema versioning?🟡 Medium · Conceptual · Asked 1×What are the main trade-offs of using materialized views?🟡 Medium · Conceptual · Asked 1×How would you troubleshoot a problem involving materialized views?🟡 Medium · Debugging · Asked 1×What is the difference between PostgreSQL and MariaDB, and when would you use each?🟢 Easy · Conceptual · Asked 1×How does SQL Server work at a high level?🟡 Medium · Conceptual · Asked 1×What are common mistakes engineers make when using Elasticsearch?🟡 Medium · Conceptual · Asked 1×How would you compare Elasticsearch and DynamoDB for a production system?🔴 Hard · Conceptual · Asked 1×What is DynamoDB, and what problem does it solve?🟢 Easy · Conceptual · Asked 1×What follow-up could reveal whether a candidate really understands connection?🟡 Medium · Conceptual · Asked 1×How should a system using joins be designed for high load or concurrency?🔴 Hard · System Design · Asked 1×How does functions compare with a common alternative?🟡 Medium · Conceptual · Asked 1×Which configuration choices matter most for indexes?🟡 Medium · Conceptual · Asked 1×What benefits and trade-offs come with plans?🟡 Medium · Conceptual · Asked 1×When is plans a poor choice for a production system?🟡 Medium · Conceptual · Asked 1×When would you use transactions, and when would you choose an alternative?🟡 Medium · Conceptual · Asked 1×When is transactions a poor choice for a production system?🟡 Medium · Conceptual · Asked 1×How would you design for failure recovery around materialized?🔴 Hard · System Design · Asked 1×When is MVCC a poor choice for a production system?🟡 Medium · Conceptual · Asked 1×What follow-up could reveal whether a candidate really understands EXPLAIN?🟢 Easy · Conceptual · Asked 1×What benefits and trade-offs come with ANALYZE?🟡 Medium · Conceptual · Asked 1×What are common mistakes when using query?🟡 Medium · Debugging · Asked 1×What metrics would you monitor for query?🟡 Medium · Conceptual · Asked 1×What would you inspect first when query is slow or unstable?🟡 Medium · Debugging · Asked 1×How is vacuum typically used in a real system?🟡 Medium · Conceptual · Asked 1×What benefits and trade-offs come with vacuum?🟡 Medium · Conceptual · Asked 1×How would you troubleshoot a problem involving vacuum?🟡 Medium · Debugging · Asked 1×How is partitioning typically used in a real system?🟡 Medium · Conceptual · Asked 1×What security considerations apply to logical?🔴 Hard · Conceptual · Asked 1×How would you document a production design that uses logical?🟡 Medium · Behavioral · Asked 1×Explain the role of replicas in production systems.🟢 Easy · Conceptual · Asked 1×When would you choose stored procedures in a real project?🟡 Medium · Conceptual · Asked 1×What are common mistakes engineers make when using triggers?🟡 Medium · Conceptual · Asked 1×How would you troubleshoot a problem involving SQLite?🟡 Medium · Debugging · Asked 1×What is MongoDB, and what problem does it solve?🟢 Easy · Conceptual · Asked 1×How can you improve the performance of a system that uses Cassandra?🟡 Medium · Conceptual · Asked 1×How would you troubleshoot a problem involving foreign keys?🟡 Medium · Debugging · Asked 1×How would you troubleshoot a problem involving EXPLAIN?🟡 Medium · Debugging · Asked 1×How would you troubleshoot a problem involving anti joins?🟡 Medium · Debugging · Asked 1×What is recursive CTEs, and what problem does it solve?🟢 Easy · Conceptual · Asked 1×What is the difference between recursive CTEs and window functions, and when would you use each?🟢 Easy · Conceptual · Asked 1×When would you choose MVCC in a real project?🟡 Medium · Conceptual · Asked 1×What is pessimistic locking, and what problem does it solve?🟢 Easy · Conceptual · Asked 1×What metrics would you monitor for functions?🟡 Medium · Conceptual · Asked 1×How would you monitor and alert on failures involving indexes?🟡 Medium · Conceptual · Asked 1×Describe a realistic interview scenario where plans would be useful.🟡 Medium · Conceptual · Asked 1×How would you monitor and alert on failures involving transactions?🟡 Medium · Conceptual · Asked 1×What benefits and trade-offs come with constraints?🟡 Medium · Conceptual · Asked 1×How is denormalization typically used in a real system?🟡 Medium · Conceptual · Asked 1×When would you use PostgreSQL, and when would you choose an alternative?🟡 Medium · Conceptual · Asked 1×When would you use logical, and when would you choose an alternative?🟡 Medium · Conceptual · Asked 1×How would you test a production implementation that uses connection?🟡 Medium · Other · Asked 1×How would you test a component that depends on relational databases?🟡 Medium · Conceptual · Asked 1×What is covering indexes, and what problem does it solve?🟢 Easy · Conceptual · Asked 1×How does B-tree indexes work at a high level?🟡 Medium · Conceptual · Asked 1×What are common mistakes engineers make when using inner joins?🟡 Medium · Conceptual · Asked 1×What are the main trade-offs of using window functions?🟡 Medium · Conceptual · Asked 1×How would you troubleshoot a problem involving window functions?🟡 Medium · Debugging · Asked 1×How would you troubleshoot a problem involving transactions?🟡 Medium · Debugging · Asked 1×How does transactions affect reliability or scalability?🟡 Medium · Conceptual · Asked 1×How can you improve the performance of a system that uses deadlocks?🟡 Medium · Conceptual · Asked 1×How can you improve the performance of a system that uses pessimistic locking?🟡 Medium · Conceptual · Asked 1×When would you choose normalization in a real project?🟡 Medium · Conceptual · Asked 1×What are the main trade-offs of using denormalization?🟡 Medium · Conceptual · Asked 1×How would you troubleshoot a problem involving PostgreSQL?🟡 Medium · Debugging · Asked 1×What are common mistakes engineers make when using PostgreSQL?🟡 Medium · Conceptual · Asked 1×What is the difference between MongoDB and Redis, and when would you use each?🟢 Easy · Conceptual · Asked 1×What are the main trade-offs of using Cassandra?🟡 Medium · Conceptual · Asked 1×When would you choose Snowflake in a real project?🟡 Medium · Conceptual · Asked 1×When would you choose denormalization in a real project?🟡 Medium · Conceptual · Asked 1×How would you troubleshoot a problem involving sharding?🟡 Medium · Debugging · Asked 1×What are the main trade-offs of using unique constraints?🟡 Medium · Conceptual · Asked 1×How can you improve the performance of a system that uses ACID properties?🟡 Medium · Conceptual · Asked 1×What are the main trade-offs of using deadlocks?🟡 Medium · Conceptual · Asked 1×What is optimistic locking, and what problem does it solve?🟢 Easy · Conceptual · Asked 1×When would you use pooling, and when would you choose an alternative?🟡 Medium · Conceptual · Asked 1×How would you explain the trade-off between correctness and performance when using window?🟢 Easy · Conceptual · Asked 1×How would you implement or configure CTE in a production environment?🟡 Medium · Coding · Asked 1×How would you migrate an existing system to plans safely?🔴 Hard · System Design · Asked 1×How is isolation typically used in a real system?🟡 Medium · Conceptual · Asked 1×Which configuration choices matter most for denormalization?🟡 Medium · Conceptual · Asked 1×Which configuration choices matter most for materialized?🟡 Medium · Conceptual · Asked 1×How would you explain the trade-off between correctness and performance when using read?🟢 Easy · Conceptual · Asked 1×How would you test a production implementation that uses replicas?🟡 Medium · Other · Asked 1×How can you improve the performance of a system that uses SQL Server?🟡 Medium · Conceptual · Asked 1×How does Cassandra work at a high level?🟡 Medium · Conceptual · Asked 1×How can you improve the performance of a system that uses relational databases?🟡 Medium · Conceptual · Asked 1×What is the difference between relational databases and primary keys, and when would you use each?🟢 Easy · Conceptual · Asked 1×How would you test a component that depends on foreign keys?🟡 Medium · Conceptual · Asked 1×What is the difference between hash indexes and query execution plans, and when would you use each?🟢 Easy · Conceptual · Asked 1×When would you choose SQL joins in a real project?🟡 Medium · Conceptual · Asked 1×How can you improve the performance of a system that uses GROUP BY?🟡 Medium · Conceptual · Asked 1×How would you test a component that depends on locks?🟡 Medium · Conceptual · Asked 1×What benefits and trade-offs come with pooling?🟡 Medium · Conceptual · Asked 1×How would you migrate an existing system to normalization safely?🔴 Hard · System Design · Asked 1×What follow-up could reveal whether a candidate really understands denormalization?🟡 Medium · Conceptual · Asked 1×How should a system using views be designed for high load or concurrency?🔴 Hard · System Design · Asked 1×Describe a realistic interview scenario where views would be useful.🟡 Medium · Conceptual · Asked 1×What would you inspect first when views is slow or unstable?🟡 Medium · Debugging · Asked 1×How would you optimize a system that depends on PostgreSQL?🟡 Medium · System Design · Asked 1×What metrics would you monitor for MVCC?🟡 Medium · Conceptual · Asked 1×Which configuration choices matter most for MVCC?🟡 Medium · Conceptual · Asked 1×What follow-up could reveal whether a candidate really understands MVCC?🟡 Medium · Conceptual · Asked 1×What edge cases should an interviewer ask about for B-tree?🟡 Medium · Conceptual · Asked 1×How does EXPLAIN compare with a common alternative?🟢 Easy · Conceptual · Asked 1×Describe a realistic interview scenario where planner would be useful.🟡 Medium · Conceptual · Asked 1×How would you migrate an existing system to analyze safely?🔴 Hard · System Design · Asked 1×How would you design for failure recovery around window?🔴 Hard · System Design · Asked 1×How would you test a production implementation that uses recursive?🟡 Medium · Other · Asked 1×How would you design for failure recovery around indexes?🔴 Hard · System Design · Asked 1×How would you implement or configure plans in a production environment?🟡 Medium · Coding · Asked 1×How would you optimize a system that depends on plans?🟡 Medium · System Design · Asked 1×What are common mistakes when using transactions?🟡 Medium · Debugging · Asked 1×What are the main trade-offs of using GROUP BY?🟡 Medium · Conceptual · Asked 1×What are common mistakes engineers make when using ACID properties?🟡 Medium · Conceptual · Asked 1×What are the main trade-offs of using triggers?🟡 Medium · Conceptual · Asked 1×When would you choose SQLite in a real project?🟡 Medium · Conceptual · Asked 1×What are common mistakes engineers make when using MongoDB?🟡 Medium · Conceptual · Asked 1×What are common mistakes engineers make when using Redis?🟡 Medium · Conceptual · Asked 1×What are common mistakes engineers make when using DynamoDB?🟡 Medium · Conceptual · Asked 1×What security considerations apply to levels?🔴 Hard · Conceptual · Asked 1×How would you optimize a system that depends on levels?🟡 Medium · System Design · Asked 1×How would you document a production design that uses normalization?🟡 Medium · Behavioral · Asked 1×What security considerations apply to ANALYZE?🔴 Hard · Conceptual · Asked 1×How would you monitor and alert on failures involving ANALYZE?🟡 Medium · Conceptual · Asked 1×What follow-up could reveal whether a candidate really understands ANALYZE?🟡 Medium · Conceptual · Asked 1×What benefits and trade-offs come with query?🟡 Medium · Conceptual · Asked 1×What would you inspect first when vacuum is slow or unstable?🟡 Medium · Debugging · Asked 1×How would you explain the trade-off between correctness and performance when using vacuum?🟢 Easy · Conceptual · Asked 1×How would you monitor and alert on failures involving vacuum?🟡 Medium · Conceptual · Asked 1×How does analyze compare with a common alternative?🟡 Medium · Conceptual · Asked 1×What follow-up could reveal whether a candidate really understands partitioning?🟡 Medium · Conceptual · Asked 1×Which configuration choices matter most for window?🟡 Medium · Conceptual · Asked 1×How would you implement or configure joins in a production environment?🟡 Medium · Coding · Asked 1×How would you implement or configure window in a production environment?🟡 Medium · Coding · Asked 1×How would you migrate an existing system to CTE safely?🔴 Hard · System Design · Asked 1×When would you use indexes, and when would you choose an alternative?🟡 Medium · Conceptual · Asked 1×How would you migrate an existing system to execution safely?🔴 Hard · System Design · Asked 1×How would you design for failure recovery around isolation?🔴 Hard · System Design · Asked 1×What follow-up could reveal whether a candidate really understands levels?🟡 Medium · Conceptual · Asked 1×How would you document a production design that uses views?🟡 Medium · Behavioral · Asked 1×Explain the role of materialized in production systems.🟢 Easy · Conceptual · Asked 1×Why is the use of MySQL important in production?🟢 Easy · Conceptual · Asked 1×How would you optimize a system that depends on MySQL?🟡 Medium · System Design · Asked 1×What benefits and trade-offs come with MVCC?🟡 Medium · Conceptual · Asked 1×How would you migrate an existing system to EXPLAIN safely?🔴 Hard · System Design · Asked 1×Explain the role of ANALYZE in production systems.🟢 Easy · Conceptual · Asked 1×How is ANALYZE typically used in a real system?🟡 Medium · Conceptual · Asked 1×What security considerations apply to partitioning?🔴 Hard · Conceptual · Asked 1×Why is the use of replicas important in production?🟢 Easy · Conceptual · Asked 1×Which configuration choices matter most for replicas?🟡 Medium · Conceptual · Asked 1×What metrics would you monitor for joins?🟡 Medium · Conceptual · Asked 1×Explain the role of functions in production systems.🟢 Easy · Conceptual · Asked 1×What benefits and trade-offs come with CTE?🟡 Medium · Conceptual · Asked 1×What benefits and trade-offs come with recursive?🟡 Medium · Conceptual · Asked 1×What edge cases should an interviewer ask about for recursive?🟡 Medium · Conceptual · Asked 1×Describe a realistic interview scenario where execution would be useful.🟡 Medium · Conceptual · Asked 1×How would you migrate an existing system to levels safely?🔴 Hard · System Design · Asked 1×How is constraints typically used in a real system?🟡 Medium · Conceptual · Asked 1×What follow-up could reveal whether a candidate really understands normalization?🟡 Medium · Conceptual · Asked 1×What are common mistakes when using views?🟡 Medium · Debugging · Asked 1×What follow-up could reveal whether a candidate really understands MySQL?🟡 Medium · Conceptual · Asked 1×How would you migrate an existing system to MVCC safely?🔴 Hard · System Design · Asked 1×When is ANALYZE a poor choice for a production system?🟡 Medium · Conceptual · Asked 1×How should a system using query be designed for high load or concurrency?🔴 Hard · System Design · Asked 1×How would you optimize a system that depends on planner?🟡 Medium · System Design · Asked 1×What follow-up could reveal whether a candidate really understands planner?🟡 Medium · Conceptual · Asked 1×What are common mistakes when using logical?🟡 Medium · Debugging · Asked 1×What are the main trade-offs of using sharding?🟡 Medium · Conceptual · Asked 1×What is replication, and what problem does it solve?🟢 Easy · Conceptual · Asked 1×How would you compare MySQL and PostgreSQL for a production system?🔴 Hard · Conceptual · Asked 1×How would you compare SQL Server and Oracle Database for a production system?🔴 Hard · Conceptual · Asked 1×How does Elasticsearch work at a high level?🟡 Medium · Conceptual · Asked 1×What are common mistakes engineers make when using BigQuery?🟡 Medium · Conceptual · Asked 1×What is the difference between Redshift and SQL injection, and when would you use each?🟢 Easy · Conceptual · Asked 1×What are common mistakes engineers make when using query execution plans?🟡 Medium · Conceptual · Asked 1×How can you improve the performance of a system that uses inner joins?🟡 Medium · Conceptual · Asked 1×How would you troubleshoot a problem involving CTEs?🟡 Medium · Debugging · Asked 1×How would you test a component that depends on ACID properties?🟡 Medium · Conceptual · Asked 1×How can you improve the performance of a system that uses isolation levels?🟡 Medium · Conceptual · Asked 1×How should a system using connection be designed for high load or concurrency?🔴 Hard · System Design · Asked 1×How is connection typically used in a real system?🟡 Medium · Conceptual · Asked 1×When would you use window, and when would you choose an alternative?🟡 Medium · Conceptual · Asked 1×How would you troubleshoot a problem involving functions?🟡 Medium · Debugging · Asked 1×How does plans compare with a common alternative?🟡 Medium · Conceptual · Asked 1×What edge cases should an interviewer ask about for transactions?🟡 Medium · Conceptual · Asked 1×How would you optimize a system that depends on MVCC?🟡 Medium · System Design · Asked 1×What metrics would you monitor for EXPLAIN?🟢 Easy · Conceptual · Asked 1×How would you document a production design that uses planner?🟡 Medium · Behavioral · Asked 1×How would you migrate an existing system to partitioning safely?🔴 Hard · System Design · Asked 1×How would you implement or configure replication in a production environment?🟡 Medium · Coding · Asked 1×What metrics would you monitor for replication?🟡 Medium · Conceptual · Asked 1×How does foreign keys work at a high level?🟡 Medium · Conceptual · Asked 1×What are common mistakes engineers make when using unique constraints?🟡 Medium · Conceptual · Asked 1×How would you test a component that depends on unique constraints?🟡 Medium · Conceptual · Asked 1×How does covering indexes affect reliability or scalability?🟡 Medium · Conceptual · Asked 1×How does B-tree indexes affect reliability or scalability?🟡 Medium · Conceptual · Asked 1×How would you test a component that depends on query execution plans?🟡 Medium · Conceptual · Asked 1×How would you troubleshoot a problem involving SQL joins?🟡 Medium · Debugging · Asked 1×How does left joins work at a high level?🟡 Medium · Conceptual · Asked 1×What is HAVING, and what problem does it solve?🟢 Easy · Conceptual · Asked 1×When would you choose ACID properties in a real project?🟡 Medium · Conceptual · Asked 1×How does isolation levels affect reliability or scalability?🟡 Medium · Conceptual · Asked 1×How would you troubleshoot a problem involving optimistic locking?🟡 Medium · Debugging · Asked 1×How can you improve the performance of a system that uses views?🟡 Medium · Conceptual · Asked 1×How can you improve the performance of a system that uses MongoDB?🟡 Medium · Conceptual · Asked 1×When would you choose DynamoDB in a real project?🟡 Medium · Conceptual · Asked 1×How would you test a production implementation that uses joins?🟡 Medium · Other · Asked 1×What security considerations apply to joins?🔴 Hard · Conceptual · Asked 1×Why is the use of indexes important in production?🟢 Easy · Conceptual · Asked 1×Explain the role of transactions in production systems.🟢 Easy · Conceptual · Asked 1×What would you inspect first when isolation is slow or unstable?🟡 Medium · Debugging · Asked 1×How is levels typically used in a real system?🟡 Medium · Conceptual · Asked 1×How would you optimize a system that depends on constraints?🟡 Medium · System Design · Asked 1×How would you design for failure recovery around normalization?🔴 Hard · System Design · Asked 1×What would you inspect first when MySQL is slow or unstable?🟡 Medium · Debugging · Asked 1×How would you design for failure recovery around MySQL?🔴 Hard · System Design · Asked 1×How would you implement or configure EXPLAIN in a production environment?🟢 Easy · Coding · Asked 1×How should a system using planner be designed for high load or concurrency?🔴 Hard · System Design · Asked 1×What are common mistakes when using analyze?🟡 Medium · Debugging · Asked 1×Which configuration choices matter most for partitioning?🟡 Medium · Conceptual · Asked 1×How would you troubleshoot a problem involving read?🟡 Medium · Debugging · Asked 1×When is read a poor choice for a production system?🟡 Medium · Conceptual · Asked 1×How would you document a production design that uses read?🟡 Medium · Behavioral · Asked 1×How would you design for failure recovery around connection?🔴 Hard · System Design · Asked 1×How does connection pooling affect reliability or scalability?🟡 Medium · Conceptual · Asked 1×How would you troubleshoot a problem involving MySQL?🟡 Medium · Debugging · Asked 1×What are the main trade-offs of using MariaDB?🟡 Medium · Conceptual · Asked 1×How would you troubleshoot a problem involving SQL Server?🟡 Medium · Debugging · Asked 1×What is the difference between SQL Server and Oracle Database, and when would you use each?🟢 Easy · Conceptual · Asked 1×When would you choose unique constraints in a real project?🟡 Medium · Conceptual · Asked 1×How does hash indexes work at a high level?🟡 Medium · Conceptual · Asked 1×What are the main trade-offs of using inner joins?🟡 Medium · Conceptual · Asked 1×What is the difference between subqueries and CTEs, and when would you use each?🟢 Easy · Conceptual · Asked 1×When would you choose primary keys in a real project?🟡 Medium · Conceptual · Asked 1×What is the difference between primary keys and foreign keys, and when would you use each?🟢 Easy · Conceptual · Asked 1×How does deadlocks affect reliability or scalability?🟡 Medium · Conceptual · Asked 1×What are the main trade-offs of using normalization?🟡 Medium · Conceptual · Asked 1×What is read replicas, and what problem does it solve?🟢 Easy · Conceptual · Asked 1×When would you choose failover in a real project?🟡 Medium · Conceptual · Asked 1×How would you troubleshoot a problem involving stored procedures?🟡 Medium · Debugging · Asked 1×How would you document a production design that uses CTE?🟡 Medium · Behavioral · Asked 1×How would you implement or configure execution in a production environment?🟡 Medium · Coding · Asked 1×Which configuration choices matter most for plans?🟡 Medium · Conceptual · Asked 1×How does normalization compare with a common alternative?🟡 Medium · Conceptual · Asked 1×What benefits and trade-offs come with PostgreSQL?🟡 Medium · Conceptual · Asked 1×What would you inspect first when EXPLAIN is slow or unstable?🟢 Easy · Debugging · Asked 1×How would you test a production implementation that uses replication?🟡 Medium · Other · Asked 1×How is read typically used in a real system?🟡 Medium · Conceptual · Asked 1×How would you troubleshoot a problem involving read replicas?🟡 Medium · Debugging · Asked 1×What is the difference between schema versioning and stored procedures, and when would you use each?🟢 Easy · Conceptual · Asked 1×What are the main trade-offs of using SQLite?🟡 Medium · Conceptual · Asked 1×What are common mistakes engineers make when using Cassandra?🟡 Medium · Conceptual · Asked 1×What are the main trade-offs of using BigQuery?🟡 Medium · Conceptual · Asked 1×How does unique constraints work at a high level?🟡 Medium · Conceptual · Asked 1×What is the difference between unique constraints and composite indexes, and when would you use each?🟢 Easy · Conceptual · Asked 1×How would you troubleshoot a problem involving query execution plans?🟡 Medium · Debugging · Asked 1×How can you improve the performance of a system that uses SQL joins?🟡 Medium · Conceptual · Asked 1×How does anti joins affect reliability or scalability?🟡 Medium · Conceptual · Asked 1×How would you migrate an existing system to replicas safely?🔴 Hard · System Design · Asked 1×Explain the role of pooling in production systems.🟢 Easy · Conceptual · Asked 1×How would you monitor and alert on failures involving normalization?🟡 Medium · Conceptual · Asked 1×How would you design for failure recovery around denormalization?🔴 Hard · System Design · Asked 1×What follow-up could reveal whether a candidate really understands PostgreSQL?🟡 Medium · Conceptual · Asked 1×What edge cases should an interviewer ask about for MVCC?🟡 Medium · Conceptual · Asked 1×How would you migrate an existing system to ANALYZE safely?🔴 Hard · System Design · Asked 1×Explain the role of query in production systems.🟢 Easy · Conceptual · Asked 1×Which configuration choices matter most for query?🟡 Medium · Conceptual · Asked 1×How would you explain the trade-off between correctness and performance when using recursive?🟢 Easy · Conceptual · Asked 1×How is transactions typically used in a real system?🟡 Medium · Conceptual · Asked 1×What follow-up could reveal whether a candidate really understands transactions?🟡 Medium · Conceptual · Asked 1×How would you test a component that depends on database migrations?🟡 Medium · Conceptual · Asked 1×How would you test a component that depends on stored procedures?🟡 Medium · Conceptual · Asked 1×What are common mistakes engineers make when using MariaDB?🟡 Medium · Conceptual · Asked 1×When would you choose MongoDB in a real project?🟡 Medium · Conceptual · Asked 1×What are the main trade-offs of using Redis?🟡 Medium · Conceptual · Asked 1×How would you troubleshoot a problem involving subqueries?🟡 Medium · Debugging · Asked 1×How does recursive CTEs affect reliability or scalability?🟡 Medium · Conceptual · Asked 1×When would you choose deadlocks in a real project?🟡 Medium · Conceptual · Asked 1×What is the difference between deadlocks and locks, and when would you use each?🟢 Easy · Conceptual · Asked 1×How would you implement or configure levels in a production environment?🟡 Medium · Coding · Asked 1×How would you explain the trade-off between correctness and performance when using denormalization?🟢 Easy · Conceptual · Asked 1×How does views compare with a common alternative?🟡 Medium · Conceptual · Asked 1×How would you monitor and alert on failures involving B-tree?🟡 Medium · Conceptual · Asked 1×What follow-up could reveal whether a candidate really understands B-tree?🟡 Medium · Conceptual · Asked 1×Why is the use of planner important in production?🟢 Easy · Conceptual · Asked 1×What metrics would you monitor for analyze?🟡 Medium · Conceptual · Asked 1×Describe a realistic interview scenario where functions would be useful.🟡 Medium · Conceptual · Asked 1×How would you monitor and alert on failures involving functions?🟡 Medium · Conceptual · Asked 1×How would you troubleshoot a problem involving CTE?🟡 Medium · Debugging · Asked 1×How would you explain the trade-off between correctness and performance when using execution?🟢 Easy · Conceptual · Asked 1×How would you design for failure recovery around pooling?🔴 Hard · System Design · Asked 1×How does composite indexes affect reliability or scalability?🟡 Medium · Conceptual · Asked 1×How would you troubleshoot a problem involving hash indexes?🟡 Medium · Debugging · Asked 1×How would you troubleshoot a problem involving recursive CTEs?🟡 Medium · Debugging · Asked 1×How does window functions affect reliability or scalability?🟡 Medium · Conceptual · Asked 1×How does GROUP BY affect reliability or scalability?🟡 Medium · Conceptual · Asked 1×How would you compare transactions and ACID properties for a production system?🔴 Hard · Conceptual · Asked 1×How does MVCC affect reliability or scalability?🟡 Medium · Conceptual · Asked 1×What is the difference between MVCC and deadlocks, and when would you use each?🟢 Easy · Conceptual · Asked 1×How does connection pooling work at a high level?🟡 Medium · Conceptual · Asked 1×How would you troubleshoot a problem involving schema versioning?🟡 Medium · Debugging · Asked 1×How does triggers work at a high level?🟡 Medium · Conceptual · Asked 1×How would you test a component that depends on MongoDB?🟡 Medium · Conceptual · Asked 1×How would you implement or configure connection in a production environment?🟡 Medium · Coding · Asked 1×When is connection a poor choice for a production system?🟡 Medium · Conceptual · Asked 1×What are common mistakes when using pooling?🟡 Medium · Debugging · Asked 1×How would you implement or configure pooling in a production environment?🟡 Medium · Coding · Asked 1×How would you migrate an existing system to recursive safely?🔴 Hard · System Design · Asked 1×How would you test a production implementation that uses execution?🟡 Medium · Other · Asked 1×How would you troubleshoot a problem involving plans?🟡 Medium · Debugging · Asked 1×How would you migrate an existing system to transactions safely?🔴 Hard · System Design · Asked 1×When would you use levels, and when would you choose an alternative?🟡 Medium · Conceptual · Asked 1×What edge cases should an interviewer ask about for levels?🟡 Medium · Conceptual · Asked 1×How would you explain the trade-off between correctness and performance when using levels?🟢 Easy · Conceptual · Asked 1×How would you design for failure recovery around views?🔴 Hard · System Design · Asked 1×How does MySQL compare with a common alternative?🟡 Medium · Conceptual · Asked 1×What would you inspect first when PostgreSQL is slow or unstable?🟡 Medium · Debugging · Asked 1×How would you document a production design that uses vacuum?🟡 Medium · Behavioral · Asked 1×When is window a poor choice for a production system?🟡 Medium · Conceptual · Asked 1×How would you explain the trade-off between correctness and performance when using CTE?🟢 Easy · Conceptual · Asked 1×How would you troubleshoot a problem involving recursive?🟡 Medium · Debugging · Asked 1×What are common mistakes when using execution?🟡 Medium · Debugging · Asked 1×When is execution a poor choice for a production system?🟡 Medium · Conceptual · Asked 1×How would you document a production design that uses transactions?🟡 Medium · Behavioral · Asked 1×Describe a realistic interview scenario where isolation would be useful.🟡 Medium · Conceptual · Asked 1×When would you use views, and when would you choose an alternative?🟡 Medium · Conceptual · Asked 1×How would you troubleshoot a problem involving materialized?🟡 Medium · Debugging · Asked 1×How does B-tree compare with a common alternative?🟡 Medium · Conceptual · Asked 1×How would you explain the trade-off between correctness and performance when using EXPLAIN?🟢 Easy · Conceptual · Asked 1×How would you migrate an existing system to planner safely?🔴 Hard · System Design · Asked 1×How would you test a component that depends on partitioning?🟡 Medium · Conceptual · Asked 1×How would you compare sharding and replication for a production system?🔴 Hard · Conceptual · Asked 1×How does replication work at a high level?🟡 Medium · Conceptual · Asked 1×What are the main trade-offs of using replication?🟡 Medium · Conceptual · Asked 1×How would you test a component that depends on Redshift?🟡 Medium · Conceptual · Asked 1×What are the main trade-offs of using SQL injection?🟡 Medium · Conceptual · Asked 1×When would you choose CTEs in a real project?🟡 Medium · Conceptual · Asked 1×What are common mistakes engineers make when using CTEs?🟡 Medium · Conceptual · Asked 1×How can you improve the performance of a system that uses window functions?🟡 Medium · Conceptual · Asked 1×How would you troubleshoot a problem involving isolation levels?🟡 Medium · Debugging · Asked 1×How can you improve the performance of a system that uses optimistic locking?🟡 Medium · Conceptual · Asked 1×How does connection compare with a common alternative?🟡 Medium · Conceptual · Asked 1×How would you troubleshoot a problem involving connection?🟡 Medium · Debugging · Asked 1×When would you use joins, and when would you choose an alternative?🟡 Medium · Conceptual · Asked 1×What security considerations apply to CTE?🔴 Hard · Conceptual · Asked 1×What would you inspect first when recursive is slow or unstable?🟡 Medium · Debugging · Asked 1×How would you document a production design that uses isolation?🟡 Medium · Behavioral · Asked 1×What metrics would you monitor for levels?🟡 Medium · Conceptual · Asked 1×Describe a realistic interview scenario where materialized would be useful.🟡 Medium · Conceptual · Asked 1×Describe a realistic interview scenario where MySQL would be useful.🟡 Medium · Conceptual · Asked 1×How would you document a production design that uses query?🟡 Medium · Behavioral · Asked 1×What metrics would you monitor for planner?🟡 Medium · Conceptual · Asked 1×How should a system using vacuum be designed for high load or concurrency?🔴 Hard · System Design · Asked 1×How would you troubleshoot a problem involving logical?🟡 Medium · Debugging · Asked 1×How would you migrate an existing system to logical safely?🔴 Hard · System Design · Asked 1×Which configuration choices matter most for read?🟡 Medium · Conceptual · Asked 1×How would you optimize a system that depends on replicas?🟡 Medium · System Design · Asked 1×What is relational databases, and what problem does it solve?🟢 Easy · Conceptual · Asked 1×What are common mistakes engineers make when using foreign keys?🟡 Medium · Conceptual · Asked 1×What is composite indexes, and what problem does it solve?🟢 Easy · Conceptual · Asked 1×How would you compare hash indexes and query execution plans for a production system?🔴 Hard · Conceptual · Asked 1×How would you test a component that depends on EXPLAIN?🟡 Medium · Conceptual · Asked 1×What is the difference between query optimization and SQL joins, and when would you use each?🟢 Easy · Conceptual · Asked 1×How would you test a component that depends on transactions?🟡 Medium · Conceptual · Asked 1×How would you troubleshoot a problem involving MVCC?🟡 Medium · Debugging · Asked 1×How does locks work at a high level?🟡 Medium · Conceptual · Asked 1×When would you choose pessimistic locking in a real project?🟡 Medium · Conceptual · Asked 1×What are the main trade-offs of using partitioning?🟡 Medium · Conceptual · Asked 1×When would you choose database migrations in a real project?🟡 Medium · Conceptual · Asked 1×How can you improve the performance of a system that uses MariaDB?🟡 Medium · Conceptual · Asked 1×What are common mistakes engineers make when using Snowflake?🟡 Medium · Conceptual · Asked 1×What metrics would you monitor for transactions?🟡 Medium · Conceptual · Asked 1×How would you implement or configure views in a production environment?🟡 Medium · Coding · Asked 1×When would you use MySQL, and when would you choose an alternative?🟡 Medium · Conceptual · Asked 1×How is MySQL typically used in a real system?🟡 Medium · Conceptual · Asked 1×Explain the role of replication in production systems.🟢 Easy · Conceptual · Asked 1×How should a system using pooling be designed for high load or concurrency?🔴 Hard · System Design · Asked 1×When would you choose partitioning in a real project?🟡 Medium · Conceptual · Asked 1×How would you troubleshoot a problem involving MariaDB?🟡 Medium · Debugging · Asked 1×What is the difference between SQLite and MongoDB, and when would you use each?🟢 Easy · Conceptual · Asked 1×What is the difference between Redis and Elasticsearch, and when would you use each?🟢 Easy · Conceptual · Asked 1×How would you troubleshoot a problem involving BigQuery?🟡 Medium · Debugging · Asked 1×How can you improve the performance of a system that uses BigQuery?🟡 Medium · Conceptual · Asked 1×How would you compare query optimization and SQL joins for a production system?🔴 Hard · Conceptual · Asked 1×How would you troubleshoot a problem involving unique constraints?🟡 Medium · Debugging · Asked 1×How does query execution plans work at a high level?🟡 Medium · Conceptual · Asked 1×What is the difference between query execution plans and EXPLAIN, and when would you use each?🟢 Easy · Conceptual · Asked 1×What are common mistakes engineers make when using left joins?🟡 Medium · Conceptual · Asked 1×How would you test a component that depends on subqueries?🟡 Medium · Conceptual · Asked 1×What is the difference between transactions and ACID properties, and when would you use each?🟢 Easy · Conceptual · Asked 1×How would you compare isolation levels and MVCC for a production system?🔴 Hard · Conceptual · Asked 1×What are the main trade-offs of using pessimistic locking?🟡 Medium · Conceptual · Asked 1×What is the difference between denormalization and partitioning, and when would you use each?🟢 Easy · Conceptual · Asked 1×How would you compare MariaDB and SQL Server for a production system?🔴 Hard · Conceptual · Asked 1×How does MongoDB affect reliability or scalability?🟡 Medium · Conceptual · Asked 1×How would you migrate an existing system to window safely?🔴 Hard · System Design · Asked 1×Describe a realistic interview scenario where CTE would be useful.🟡 Medium · Conceptual · Asked 1×What follow-up could reveal whether a candidate really understands recursive?🟡 Medium · Conceptual · Asked 1×What security considerations apply to plans?🔴 Hard · Conceptual · Asked 1×How would you monitor and alert on failures involving constraints?🟡 Medium · Conceptual · Asked 1×When is normalization a poor choice for a production system?🟡 Medium · Conceptual · Asked 1×How would you implement or configure PostgreSQL in a production environment?🟡 Medium · Coding · Asked 1×What security considerations apply to MVCC?🔴 Hard · Conceptual · Asked 1×How would you optimize a system that depends on B-tree?🟡 Medium · System Design · Asked 1×Describe a realistic interview scenario where logical would be useful.🟡 Medium · Conceptual · Asked 1×What is the difference between failover and connection pooling, and when would you use each?🟢 Easy · Conceptual · Asked 1×What is connection pooling, and what problem does it solve?🟢 Easy · Conceptual · Asked 1×What is schema versioning, and what problem does it solve?🟢 Easy · Conceptual · Asked 1×How does views affect reliability or scalability?🟡 Medium · Conceptual · Asked 1×What is MySQL, and what problem does it solve?🟢 Easy · Conceptual · Asked 1×How would you test a component that depends on PostgreSQL?🟡 Medium · Conceptual · Asked 1×What is SQL Server, and what problem does it solve?🟢 Easy · Conceptual · Asked 1×How would you compare Redis and Elasticsearch for a production system?🔴 Hard · Conceptual · Asked 1×What is the difference between foreign keys and unique constraints, and when would you use each?🟢 Easy · Conceptual · Asked 1×How does query execution plans affect reliability or scalability?🟡 Medium · Conceptual · Asked 1×How does EXPLAIN affect reliability or scalability?🟡 Medium · Conceptual · Asked 1×How does left joins affect reliability or scalability?🟡 Medium · Conceptual · Asked 1×How would you compare subqueries and CTEs for a production system?🔴 Hard · Conceptual · Asked 1×How does CTEs work at a high level?🟡 Medium · Conceptual · Asked 1×How does recursive CTEs work at a high level?🟡 Medium · Conceptual · Asked 1×How would you compare HAVING and transactions for a production system?🔴 Hard · Conceptual · Asked 1×How does MVCC work at a high level?🟡 Medium · Conceptual · Asked 1×How does deadlocks work at a high level?🟡 Medium · Conceptual · Asked 1×Why is the use of constraints important in production?🟢 Easy · Conceptual · Asked 1×Explain the role of denormalization in production systems.🟢 Easy · Conceptual · Asked 1×When would you use denormalization, and when would you choose an alternative?🟡 Medium · Conceptual · Asked 1×How would you migrate an existing system to denormalization safely?🔴 Hard · System Design · Asked 1×How would you monitor and alert on failures involving denormalization?🟡 Medium · Conceptual · Asked 1×What security considerations apply to materialized?🔴 Hard · Conceptual · Asked 1×What would you inspect first when materialized is slow or unstable?🟡 Medium · Debugging · Asked 1×How would you implement or configure vacuum in a production environment?🟡 Medium · Coding · Asked 1×Explain the role of logical in production systems.🟢 Easy · Conceptual · Asked 1×How would you design for failure recovery around logical?🔴 Hard · System Design · Asked 1×How would you implement or configure replicas in a production environment?🟡 Medium · Coding · Asked 1×Describe a realistic interview scenario where replicas would be useful.🟡 Medium · Conceptual · Asked 1×How would you explain the trade-off between correctness and performance when using replicas?🟢 Easy · Conceptual · Asked 1×Which configuration choices matter most for functions?🟡 Medium · Conceptual · Asked 1×When would you use subqueries, and when would you choose an alternative?🟡 Medium · Conceptual · Asked 1×How should a system using indexes be designed for high load or concurrency?🔴 Hard · System Design · Asked 1×How can you improve the performance of a system that uses normalization?🟡 Medium · Conceptual · Asked 1×When would you choose read replicas in a real project?🟡 Medium · Conceptual · Asked 1×What are the main trade-offs of using failover?🟡 Medium · Conceptual · Asked 1×How would you troubleshoot a problem involving failover?🟡 Medium · Debugging · Asked 1×How would you troubleshoot a problem involving database migrations?🟡 Medium · Debugging · Asked 1×How does stored procedures work at a high level?🟡 Medium · Conceptual · Asked 1×How would you compare stored procedures and triggers for a production system?🔴 Hard · Conceptual · Asked 1×What are common mistakes engineers make when using views?🟡 Medium · Conceptual · Asked 1×How would you test a component that depends on views?🟡 Medium · Conceptual · Asked 1×What is PostgreSQL, and what problem does it solve?🟢 Easy · Conceptual · Asked 1×What are common mistakes engineers make when using Redshift?🟡 Medium · Conceptual · Asked 1×How does query optimization affect reliability or scalability?🟡 Medium · Conceptual · Asked 1×What are the main trade-offs of using recursive CTEs?🟡 Medium · Conceptual · Asked 1×How would you compare window functions and GROUP BY for a production system?🔴 Hard · Conceptual · Asked 1×How would you compare GROUP BY and HAVING for a production system?🔴 Hard · Conceptual · Asked 1×How can you improve the performance of a system that uses HAVING?🟡 Medium · Conceptual · Asked 1×Describe a realistic interview scenario where levels would be useful.🟡 Medium · Conceptual · Asked 1×How should a system using constraints be designed for high load or concurrency?🔴 Hard · System Design · Asked 1×What metrics would you monitor for constraints?🟡 Medium · Conceptual · Asked 1×How would you optimize a system that depends on views?🟡 Medium · System Design · Asked 1×How would you design for failure recovery around query?🔴 Hard · System Design · Asked 1×What would you inspect first when planner is slow or unstable?🟡 Medium · Debugging · Asked 1×When would you use replicas, and when would you choose an alternative?🟡 Medium · Conceptual · Asked 1×What benefits and trade-offs come with joins?🟡 Medium · Conceptual · Asked 1×How would you optimize a system that depends on joins?🟡 Medium · System Design · Asked 1×What follow-up could reveal whether a candidate really understands window?🟡 Medium · Conceptual · Asked 1×What edge cases should an interviewer ask about for CTE?🟡 Medium · Conceptual · Asked 1×What security considerations apply to execution?🔴 Hard · Conceptual · Asked 1×What edge cases should an interviewer ask about for plans?🟡 Medium · Conceptual · Asked 1×How should a system using transactions be designed for high load or concurrency?🔴 Hard · System Design · Asked 1×Why is the use of isolation important in production?🟢 Easy · Conceptual · Asked 1×When is replicas a poor choice for a production system?🟡 Medium · Conceptual · Asked 1×What would you inspect first when pooling is slow or unstable?🟡 Medium · Debugging · Asked 1×How would you troubleshoot a problem involving B-tree indexes?🟡 Medium · Debugging · Asked 1×What is query optimization, and what problem does it solve?🟢 Easy · Conceptual · Asked 1×When would you choose anti joins in a real project?🟡 Medium · Conceptual · Asked 1×How would you test a component that depends on anti joins?🟡 Medium · Conceptual · Asked 1×What are common mistakes engineers make when using self joins?🟡 Medium · Conceptual · Asked 1×How does subqueries work at a high level?🟡 Medium · Conceptual · Asked 1×What is CTEs, and what problem does it solve?🟢 Easy · Conceptual · Asked 1×How would you troubleshoot a problem involving GROUP BY?🟡 Medium · Debugging · Asked 1×How would you test a component that depends on isolation levels?🟡 Medium · Conceptual · Asked 1×What is MVCC, and what problem does it solve?🟢 Easy · Conceptual · Asked 1×When would you choose SQL Server in a real project?🟡 Medium · Conceptual · Asked 1×What are common mistakes engineers make when using SQLite?🟡 Medium · Conceptual · Asked 1×How would you troubleshoot a problem involving MongoDB?🟡 Medium · Debugging · Asked 1×How would you compare MongoDB and Redis for a production system?🔴 Hard · Conceptual · Asked 1×How would you troubleshoot a problem involving Cassandra?🟡 Medium · Debugging · Asked 1×What are the main trade-offs of using Snowflake?🟡 Medium · Conceptual · Asked 1×What is BigQuery, and what problem does it solve?🟢 Easy · Conceptual · Asked 1×How does BigQuery work at a high level?🟡 Medium · Conceptual · Asked 1×How is subqueries typically used in a real system?🟡 Medium · Conceptual · Asked 1×What edge cases should an interviewer ask about for indexes?🟡 Medium · Conceptual · Asked 1×Which configuration choices matter most for execution?🟡 Medium · Conceptual · Asked 1×When is constraints a poor choice for a production system?🟡 Medium · Conceptual · Asked 1×What metrics would you monitor for normalization?🟡 Medium · Conceptual · Asked 1×What follow-up could reveal whether a candidate really understands views?🟡 Medium · Conceptual · Asked 1×What are common mistakes when using MySQL?🟡 Medium · Debugging · Asked 1×How would you test a production implementation that uses MySQL?🟡 Medium · Other · Asked 1×Which configuration choices matter most for PostgreSQL?🟡 Medium · Conceptual · Asked 1×What are common mistakes when using B-tree?🟡 Medium · Debugging · Asked 1×What would you inspect first when B-tree is slow or unstable?🟡 Medium · Debugging · Asked 1×How would you migrate an existing system to B-tree safely?🔴 Hard · System Design · Asked 1×Why is the use of EXPLAIN important in production?🟢 Easy · Conceptual · Asked 1×How would you migrate an existing system to query safely?🔴 Hard · System Design · Asked 1×What are common mistakes when using replication?🟡 Medium · Debugging · Asked 1×How would you document a production design that uses replication?🟡 Medium · Behavioral · Asked 1×How would you optimize a system that depends on read?🟡 Medium · System Design · Asked 1×How would you monitor and alert on failures involving window?🟡 Medium · Conceptual · Asked 1×How would you design for failure recovery around functions?🔴 Hard · System Design · Asked 1×What metrics would you monitor for subqueries?🟡 Medium · Conceptual · Asked 1×How would you optimize a system that depends on indexes?🟡 Medium · System Design · Asked 1×Why is the use of normalization important in production?🟢 Easy · Conceptual · Asked 1×How would you explain the trade-off between correctness and performance when using normalization?🟢 Easy · Conceptual · Asked 1×What edge cases should an interviewer ask about for denormalization?🟡 Medium · Conceptual · Asked 1×What metrics would you monitor for MySQL?🟡 Medium · Conceptual · Asked 1×When is MySQL a poor choice for a production system?🟡 Medium · Conceptual · Asked 1×How would you implement or configure B-tree in a production environment?🟡 Medium · Coding · Asked 1×How would you troubleshoot a problem involving query?🟡 Medium · Debugging · Asked 1×How does query compare with a common alternative?🟡 Medium · Conceptual · Asked 1×How does vacuum compare with a common alternative?🟡 Medium · Conceptual · Asked 1×When would you use analyze, and when would you choose an alternative?🟡 Medium · Conceptual · Asked 1×What are common mistakes when using partitioning?🟡 Medium · Debugging · Asked 1×How would you explain the trade-off between correctness and performance when using partitioning?🟢 Easy · Conceptual · Asked 1×How would you troubleshoot a problem involving normalization?🟡 Medium · Debugging · Asked 1×How can you improve the performance of a system that uses failover?🟡 Medium · Conceptual · Asked 1×How can you improve the performance of a system that uses connection pooling?🟡 Medium · Conceptual · Asked 1×How does schema versioning affect reliability or scalability?🟡 Medium · Conceptual · Asked 1×How can you improve the performance of a system that uses stored procedures?🟡 Medium · Conceptual · Asked 1×How does SQL injection work at a high level?🟡 Medium · Conceptual · Asked 1×How would you test a component that depends on hash indexes?🟡 Medium · Conceptual · Asked 1×How would you compare query execution plans and EXPLAIN for a production system?🔴 Hard · Conceptual · Asked 1×What are the main trade-offs of using EXPLAIN?🟡 Medium · Conceptual · Asked 1×What are the main trade-offs of using query optimization?🟡 Medium · Conceptual · Asked 1×How would you migrate an existing system to connection safely?🔴 Hard · System Design · Asked 1×Describe a realistic interview scenario where pooling would be useful.🟡 Medium · Conceptual · Asked 1×How would you document a production design that uses replicas?🟡 Medium · Behavioral · Asked 1×What are common mistakes when using functions?🟡 Medium · Debugging · Asked 1×What follow-up could reveal whether a candidate really understands subqueries?🟡 Medium · Conceptual · Asked 1×How is indexes typically used in a real system?🟡 Medium · Conceptual · Asked 1×What benefits and trade-offs come with execution?🟡 Medium · Conceptual · Asked 1×What edge cases should an interviewer ask about for execution?🟡 Medium · Conceptual · Asked 1×How would you troubleshoot a problem involving constraints?🟡 Medium · Debugging · Asked 1×How would you explain the trade-off between correctness and performance when using B-tree?🟢 Easy · Conceptual · Asked 1×How is EXPLAIN typically used in a real system?🟢 Easy · Conceptual · Asked 1×What benefits and trade-offs come with EXPLAIN?🟢 Easy · Conceptual · Asked 1×How would you optimize a system that depends on EXPLAIN?🟢 Easy · System Design · Asked 1×Which configuration choices matter most for EXPLAIN?🟢 Easy · Conceptual · Asked 1×When would you use ANALYZE, and when would you choose an alternative?🟡 Medium · Conceptual · Asked 1×What edge cases should an interviewer ask about for query?🟡 Medium · Conceptual · Asked 1×When is partitioning a poor choice for a production system?🟡 Medium · Conceptual · Asked 1×How would you test a production implementation that uses logical?🟡 Medium · Other · Asked 1×How would you troubleshoot a problem involving inner joins?🟡 Medium · Debugging · Asked 1×How would you test a component that depends on recursive CTEs?🟡 Medium · Conceptual · Asked 1×How would you compare PostgreSQL and MariaDB for a production system?🔴 Hard · Conceptual · Asked 1×How would you test a component that depends on SQL Server?🟡 Medium · Conceptual · Asked 1×How would you compare Oracle Database and SQLite for a production system?🔴 Hard · Conceptual · Asked 1×How would you compare SQLite and MongoDB for a production system?🔴 Hard · Conceptual · Asked 1×How would you troubleshoot a problem involving Redis?🟡 Medium · Debugging · Asked 1×What are the main trade-offs of using Redshift?🟡 Medium · Conceptual · Asked 1×How should a system using functions be designed for high load or concurrency?🔴 Hard · System Design · Asked 1×Explain the role of CTE in production systems.🟢 Easy · Conceptual · Asked 1×What benefits and trade-offs come with subqueries?🟡 Medium · Conceptual · Asked 1×How would you troubleshoot a problem involving execution?🟡 Medium · Debugging · Asked 1×How should a system using execution be designed for high load or concurrency?🔴 Hard · System Design · Asked 1×How would you troubleshoot a problem involving levels?🟡 Medium · Debugging · Asked 1×How would you test a production implementation that uses levels?🟡 Medium · Other · Asked 1×What security considerations apply to constraints?🔴 Hard · Conceptual · Asked 1×How is normalization typically used in a real system?🟡 Medium · Conceptual · Asked 1×Why is the use of denormalization important in production?🟢 Easy · Conceptual · Asked 1×Why is the use of views important in production?🟢 Easy · Conceptual · Asked 1×How would you monitor and alert on failures involving PostgreSQL?🟡 Medium · Conceptual · Asked 1×When is vacuum a poor choice for a production system?🟡 Medium · Conceptual · Asked 1×Explain the role of analyze in production systems.🟢 Easy · Conceptual · Asked 1×Why is the use of partitioning important in production?🟢 Easy · Conceptual · Asked 1×Why is the use of logical important in production?🟢 Easy · Conceptual · Asked 1×What is stored procedures, and what problem does it solve?🟢 Easy · Conceptual · Asked 1×What is the difference between stored procedures and triggers, and when would you use each?🟢 Easy · Conceptual · Asked 1×What is views, and what problem does it solve?🟢 Easy · Conceptual · Asked 1×How does SQLite affect reliability or scalability?🟡 Medium · Conceptual · Asked 1×How would you compare DynamoDB and Cassandra for a production system?🔴 Hard · Conceptual · Asked 1×What is Redshift, and what problem does it solve?🟢 Easy · Conceptual · Asked 1×What are common mistakes engineers make when using covering indexes?🟡 Medium · Conceptual · Asked 1×What is the difference between left joins and anti joins, and when would you use each?🟢 Easy · Conceptual · Asked 1×What are the main trade-offs of using hash indexes?🟡 Medium · Conceptual · Asked 1×What are common mistakes engineers make when using subqueries?🟡 Medium · Conceptual · Asked 1×What is the difference between locks and optimistic locking, and when would you use each?🟢 Easy · Conceptual · Asked 1×How does optimistic locking work at a high level?🟡 Medium · Conceptual · Asked 1×How would you test a component that depends on sharding?🟡 Medium · Conceptual · Asked 1×How does Redis work at a high level?🟡 Medium · Conceptual · Asked 1×How does DynamoDB work at a high level?🟡 Medium · Conceptual · Asked 1×When would you use functions, and when would you choose an alternative?🟡 Medium · Conceptual · Asked 1×What metrics would you monitor for recursive?🟡 Medium · Conceptual · Asked 1×What follow-up could reveal whether a candidate really understands isolation?🟡 Medium · Conceptual · Asked 1×What would you inspect first when levels is slow or unstable?🟡 Medium · Debugging · Asked 1×How would you document a production design that uses PostgreSQL?🟡 Medium · Behavioral · Asked 1×How is B-tree typically used in a real system?🟡 Medium · Conceptual · Asked 1×How does ANALYZE compare with a common alternative?🟡 Medium · Conceptual · Asked 1×How would you document a production design that uses partitioning?🟡 Medium · Behavioral · Asked 1×How would you test a component that depends on pessimistic locking?🟡 Medium · Conceptual · Asked 1×How does sharding work at a high level?🟡 Medium · Conceptual · Asked 1×How does failover work at a high level?🟡 Medium · Conceptual · Asked 1×How does database migrations affect reliability or scalability?🟡 Medium · Conceptual · Asked 1×How does Redis affect reliability or scalability?🟡 Medium · Conceptual · Asked 1×What are the main trade-offs of using DynamoDB?🟡 Medium · Conceptual · Asked 1×How does inner joins work at a high level?🟡 Medium · Conceptual · Asked 1×What are the main trade-offs of using MVCC?🟡 Medium · Conceptual · Asked 1×How would you test a component that depends on deadlocks?🟡 Medium · Conceptual · Asked 1×How would you test a production implementation that uses constraints?🟡 Medium · Other · Asked 1×What metrics would you monitor for materialized?🟡 Medium · Conceptual · Asked 1×What security considerations apply to B-tree?🔴 Hard · Conceptual · Asked 1×How should a system using EXPLAIN be designed for high load or concurrency?🔴 Hard · System Design · Asked 1×How would you explain the trade-off between correctness and performance when using ANALYZE?🟢 Easy · Conceptual · Asked 1×How would you troubleshoot a problem involving analyze?🟡 Medium · Debugging · Asked 1×When would you use partitioning, and when would you choose an alternative?🟡 Medium · Conceptual · Asked 1×How would you optimize a system that depends on replication?🟡 Medium · System Design · Asked 1×What benefits and trade-offs come with logical?🟡 Medium · Conceptual · Asked 1×What metrics would you monitor for window?🟡 Medium · Conceptual · Asked 1×When is functions a poor choice for a production system?🟡 Medium · Conceptual · Asked 1×What metrics would you monitor for CTE?🟡 Medium · Conceptual · Asked 1×How should a system using subqueries be designed for high load or concurrency?🔴 Hard · System Design · Asked 1×What follow-up could reveal whether a candidate really understands indexes?🟡 Medium · Conceptual · Asked 1×How is plans typically used in a real system?🟡 Medium · Conceptual · Asked 1×How does isolation compare with a common alternative?🟡 Medium · Conceptual · Asked 1×What is the difference between normalization and denormalization, and when would you use each?🟢 Easy · Conceptual · Asked 1×What is the difference between replication and read replicas, and when would you use each?🟢 Easy · Conceptual · Asked 1×How would you compare replication and read replicas for a production system?🔴 Hard · Conceptual · Asked 1×How does read replicas affect reliability or scalability?🟡 Medium · Conceptual · Asked 1×How would you compare read replicas and failover for a production system?🔴 Hard · Conceptual · Asked 1×What is Oracle Database, and what problem does it solve?🟢 Easy · Conceptual · Asked 1×How does Oracle Database work at a high level?🟡 Medium · Conceptual · Asked 1×How would you test a component that depends on SQLite?🟡 Medium · Conceptual · Asked 1×How does Snowflake work at a high level?🟡 Medium · Conceptual · Asked 1×How would you compare foreign keys and unique constraints for a production system?🔴 Hard · Conceptual · Asked 1×What is the difference between HAVING and transactions, and when would you use each?🟢 Easy · Conceptual · Asked 1×How would you troubleshoot a problem involving ACID properties?🟡 Medium · Debugging · Asked 1×What are common mistakes when using constraints?🟡 Medium · Debugging · Asked 1×How would you migrate an existing system to views safely?🔴 Hard · System Design · Asked 1×What security considerations apply to MySQL?🔴 Hard · Conceptual · Asked 1×How would you design for failure recovery around MVCC?🔴 Hard · System Design · Asked 1×Why is the use of B-tree important in production?🟢 Easy · Conceptual · Asked 1×What benefits and trade-offs come with B-tree?🟡 Medium · Conceptual · Asked 1×Describe a realistic interview scenario where vacuum would be useful.🟡 Medium · Conceptual · Asked 1×Which configuration choices matter most for replication?🟡 Medium · Conceptual · Asked 1×How does subqueries compare with a common alternative?🟡 Medium · Conceptual · Asked 1×Explain the role of indexes in production systems.🟢 Easy · Conceptual · Asked 1×What is primary keys, and what problem does it solve?🟢 Easy · Conceptual · Asked 1×What is inner joins, and what problem does it solve?🟢 Easy · Conceptual · Asked 1×How does ACID properties work at a high level?🟡 Medium · Conceptual · Asked 1×How does failover affect reliability or scalability?🟡 Medium · Conceptual · Asked 1×When would you choose MariaDB in a real project?🟡 Medium · Conceptual · Asked 1×How would you troubleshoot a problem involving Redshift?🟡 Medium · Debugging · Asked 1×How does Redshift affect reliability or scalability?🟡 Medium · Conceptual · Asked 1×What are common mistakes when using connection?🟡 Medium · Debugging · Asked 1×What security considerations apply to window?🔴 Hard · Conceptual · Asked 1×How would you explain the trade-off between correctness and performance when using transactions?🟢 Easy · Conceptual · Asked 1×How would you implement or configure constraints in a production environment?🟡 Medium · Coding · Asked 1×Describe a realistic interview scenario where constraints would be useful.🟡 Medium · Conceptual · Asked 1×What security considerations apply to normalization?🔴 Hard · Conceptual · Asked 1×Which configuration choices matter most for MySQL?🟡 Medium · Conceptual · Asked 1×When is EXPLAIN a poor choice for a production system?🟢 Easy · Conceptual · Asked 1×How would you implement or configure ANALYZE in a production environment?🟡 Medium · Coding · Asked 1×How would you implement or configure query in a production environment?🟡 Medium · Coding · Asked 1×Which configuration choices matter most for vacuum?🟡 Medium · Conceptual · Asked 1×How should a system using partitioning be designed for high load or concurrency?🔴 Hard · System Design · Asked 1×Why is the use of replication important in production?🟢 Easy · Conceptual · Asked 1×Describe a realistic interview scenario where window would be useful.🟡 Medium · Conceptual · Asked 1×How would you test a production implementation that uses functions?🟡 Medium · Other · Asked 1×How would you monitor and alert on failures involving recursive?🟡 Medium · Conceptual · Asked 1×How would you document a production design that uses indexes?🟡 Medium · Behavioral · Asked 1×What follow-up could reveal whether a candidate really understands execution?🟡 Medium · Conceptual · Asked 1×How would you design for failure recovery around transactions?🔴 Hard · System Design · Asked 1×Explain the role of constraints in production systems.🟢 Easy · Conceptual · Asked 1×What follow-up could reveal whether a candidate really understands constraints?🟡 Medium · Conceptual · Asked 1×What are common mistakes when using normalization?🟡 Medium · Debugging · Asked 1×Why is the use of materialized important in production?🟢 Easy · Conceptual · Asked 1×What edge cases should an interviewer ask about for EXPLAIN?🟢 Easy · Conceptual · Asked 1×What edge cases should an interviewer ask about for ANALYZE?🟡 Medium · Conceptual · Asked 1×When would you use vacuum, and when would you choose an alternative?🟡 Medium · Conceptual · Asked 1×How would you document a production design that uses analyze?🟡 Medium · Behavioral · Asked 1×How is logical typically used in a real system?🟡 Medium · Conceptual · Asked 1×What edge cases should an interviewer ask about for logical?🟡 Medium · Conceptual · Asked 1×What are the main trade-offs of using read replicas?🟡 Medium · Conceptual · Asked 1×What is the difference between triggers and views, and when would you use each?🟢 Easy · Conceptual · Asked 1×How does views work at a high level?🟡 Medium · Conceptual · Asked 1×What are the main trade-offs of using views?🟡 Medium · Conceptual · Asked 1×How would you test a component that depends on materialized views?🟡 Medium · Conceptual · Asked 1×What are common mistakes engineers make when using MySQL?🟡 Medium · Conceptual · Asked 1×When would you choose Redis in a real project?🟡 Medium · Conceptual · Asked 1×How would you test a component that depends on Cassandra?🟡 Medium · Conceptual · Asked 1×How would you troubleshoot a problem involving Snowflake?🟡 Medium · Debugging · Asked 1×How does Snowflake affect reliability or scalability?🟡 Medium · Conceptual · Asked 1×How can you improve the performance of a system that uses primary keys?🟡 Medium · Conceptual · Asked 1×When would you choose hash indexes in a real project?🟡 Medium · Conceptual · Asked 1×How does SQL joins work at a high level?🟡 Medium · Conceptual · Asked 1×How does SQL joins affect reliability or scalability?🟡 Medium · Conceptual · Asked 1×What is anti joins, and what problem does it solve?🟢 Easy · Conceptual · Asked 1×What are the main trade-offs of using anti joins?🟡 Medium · Conceptual · Asked 1×How would you troubleshoot a problem involving self joins?🟡 Medium · Debugging · Asked 1×What is subqueries, and what problem does it solve?🟢 Easy · Conceptual · Asked 1×How would you test a component that depends on window functions?🟡 Medium · Conceptual · Asked 1×What is the difference between optimistic locking and pessimistic locking, and when would you use each?🟢 Easy · Conceptual · Asked 1×How would you monitor and alert on failures involving connection?🟡 Medium · Conceptual · Asked 1×What security considerations apply to connection?🔴 Hard · Conceptual · Asked 1×How would you migrate an existing system to joins safely?🔴 Hard · System Design · Asked 1×How would you implement or configure functions in a production environment?🟡 Medium · Coding · Asked 1×What security considerations apply to recursive?🔴 Hard · Conceptual · Asked 1×Which configuration choices matter most for subqueries?🟡 Medium · Conceptual · Asked 1×How would you design for failure recovery around execution?🔴 Hard · System Design · Asked 1×What security considerations apply to isolation?🔴 Hard · Conceptual · Asked 1×What benefits and trade-offs come with views?🟡 Medium · Conceptual · Asked 1×What benefits and trade-offs come with materialized?🟡 Medium · Conceptual · Asked 1×How would you implement or configure materialized in a production environment?🟡 Medium · Coding · Asked 1×How is MVCC typically used in a real system?🟡 Medium · Conceptual · Asked 1×What would you inspect first when MVCC is slow or unstable?🟡 Medium · Debugging · Asked 1×How would you explain the trade-off between correctness and performance when using MVCC?🟢 Easy · Conceptual · Asked 1×How does planner compare with a common alternative?🟡 Medium · Conceptual · Asked 1×What edge cases should an interviewer ask about for planner?🟡 Medium · Conceptual · Asked 1×Which configuration choices matter most for planner?🟡 Medium · Conceptual · Asked 1×How is replication typically used in a real system?🟡 Medium · Conceptual · Asked 1×What edge cases should an interviewer ask about for read?🟡 Medium · Conceptual · Asked 1×How does foreign keys affect reliability or scalability?🟡 Medium · Conceptual · Asked 1×What are the main trade-offs of using B-tree indexes?🟡 Medium · Conceptual · Asked 1×What are the main trade-offs of using query execution plans?🟡 Medium · Conceptual · Asked 1×How can you improve the performance of a system that uses query optimization?🟡 Medium · Conceptual · Asked 1×How does anti joins work at a high level?🟡 Medium · Conceptual · Asked 1×How would you compare self joins and subqueries for a production system?🔴 Hard · Conceptual · Asked 1×How can you improve the performance of a system that uses CTEs?🟡 Medium · Conceptual · Asked 1×When would you choose HAVING in a real project?🟡 Medium · Conceptual · Asked 1×How would you test a component that depends on HAVING?🟡 Medium · Conceptual · Asked 1×How would you troubleshoot a problem involving replication?🟡 Medium · Debugging · Asked 1×How can you improve the performance of a system that uses replication?🟡 Medium · Conceptual · Asked 1×How can you improve the performance of a system that uses database migrations?🟡 Medium · Conceptual · Asked 1×When would you choose views in a real project?🟡 Medium · Conceptual · Asked 1×What is materialized views, and what problem does it solve?🟢 Easy · Conceptual · Asked 1×How can you improve the performance of a system that uses materialized views?🟡 Medium · Conceptual · Asked 1×What are common mistakes engineers make when using SQL Server?🟡 Medium · Conceptual · Asked 1×What are the main trade-offs of using Oracle Database?🟡 Medium · Conceptual · Asked 1×Explain the role of window in production systems.🟢 Easy · Conceptual · Asked 1×What metrics would you monitor for indexes?🟡 Medium · Conceptual · Asked 1×What are common mistakes when using isolation?🟡 Medium · Debugging · Asked 1×How would you test a production implementation that uses views?🟡 Medium · Other · Asked 1×What are common mistakes when using materialized?🟡 Medium · Debugging · Asked 1×How would you test a production implementation that uses PostgreSQL?🟡 Medium · Other · Asked 1×What follow-up could reveal whether a candidate really understands replication?🟡 Medium · Conceptual · Asked 1×How would you monitor and alert on failures involving logical?🟡 Medium · Conceptual · Asked 1×How should a system using read be designed for high load or concurrency?🔴 Hard · System Design · Asked 1×What benefits and trade-offs come with connection?🟡 Medium · Conceptual · Asked 1×How would you migrate an existing system to pooling safely?🔴 Hard · System Design · Asked 1×What are common mistakes engineers make when using pessimistic locking?🟡 Medium · Conceptual · Asked 1×What are common mistakes engineers make when using partitioning?🟡 Medium · Conceptual · Asked 1×What is the difference between connection pooling and database migrations, and when would you use each?🟢 Easy · Conceptual · Asked 1×How does materialized views affect reliability or scalability?🟡 Medium · Conceptual · Asked 1×What are the main trade-offs of using MySQL?🟡 Medium · Conceptual · Asked 1×How does MongoDB work at a high level?🟡 Medium · Conceptual · Asked 1×How would you test a component that depends on BigQuery?🟡 Medium · Conceptual · Asked 1×How does relational databases affect reliability or scalability?🟡 Medium · Conceptual · Asked 1×How can you improve the performance of a system that uses foreign keys?🟡 Medium · Conceptual · Asked 1×What is SQL joins, and what problem does it solve?🟢 Easy · Conceptual · Asked 1×How would you test a component that depends on left joins?🟡 Medium · Conceptual · Asked 1×How does CTEs affect reliability or scalability?🟡 Medium · Conceptual · Asked 1×What is transactions, and what problem does it solve?🟢 Easy · Conceptual · Asked 1×What are common mistakes engineers make when using transactions?🟡 Medium · Conceptual · Asked 1×How can you improve the performance of a system that uses MVCC?🟡 Medium · Conceptual · Asked 1×How does optimistic locking affect reliability or scalability?🟡 Medium · Conceptual · Asked 1×When would you choose covering indexes in a real project?🟡 Medium · Conceptual · Asked 1×How does EXPLAIN work at a high level?🟡 Medium · Conceptual · Asked 1×How would you test a component that depends on inner joins?🟡 Medium · Conceptual · Asked 1×What is the difference between CTEs and recursive CTEs, and when would you use each?🟢 Easy · Conceptual · Asked 1×How does transactions work at a high level?🟡 Medium · Conceptual · Asked 1×How does locks affect reliability or scalability?🟡 Medium · Conceptual · Asked 1×How does pessimistic locking work at a high level?🟡 Medium · Conceptual · Asked 1×What is denormalization, and what problem does it solve?🟢 Easy · Conceptual · Asked 1×How does denormalization affect reliability or scalability?🟡 Medium · Conceptual · Asked 1×What are common mistakes engineers make when using read replicas?🟡 Medium · Conceptual · Asked 1×When would you choose Oracle Database in a real project?🟡 Medium · Conceptual · Asked 1×When would you choose BigQuery in a real project?🟡 Medium · Conceptual · Asked 1×What edge cases should an interviewer ask about for connection?🟡 Medium · Conceptual · Asked 1×How is joins typically used in a real system?🟡 Medium · Conceptual · Asked 1×How would you troubleshoot a problem involving joins?🟡 Medium · Debugging · Asked 1×How would you troubleshoot a problem involving window?🟡 Medium · Debugging · Asked 1×How would you optimize a system that depends on recursive?🟡 Medium · System Design · Asked 1×What would you inspect first when transactions is slow or unstable?🟡 Medium · Debugging · Asked 1×What benefits and trade-offs come with levels?🟡 Medium · Conceptual · Asked 1×How would you test a production implementation that uses normalization?🟡 Medium · Other · Asked 1×Describe a realistic interview scenario where denormalization would be useful.🟡 Medium · Conceptual · Asked 1×How would you migrate an existing system to PostgreSQL safely?🔴 Hard · System Design · Asked 1×Why is the use of MVCC important in production?🟢 Easy · Conceptual · Asked 1×How would you optimize a system that depends on query?🟡 Medium · System Design · Asked 1×What security considerations apply to vacuum?🔴 Hard · Conceptual · Asked 1×What security considerations apply to analyze?🔴 Hard · Conceptual · Asked 1×What would you inspect first when analyze is slow or unstable?🟡 Medium · Debugging · Asked 1×Describe a realistic interview scenario where partitioning would be useful.🟡 Medium · Conceptual · Asked 1×What are common mistakes engineers make when using denormalization?🟡 Medium · Conceptual · Asked 1×When would you choose sharding in a real project?🟡 Medium · Conceptual · Asked 1×How can you improve the performance of a system that uses sharding?🟡 Medium · Conceptual · Asked 1×When would you choose replication in a real project?🟡 Medium · Conceptual · Asked 1×How would you test a component that depends on failover?🟡 Medium · Conceptual · Asked 1×When would you choose connection pooling in a real project?🟡 Medium · Conceptual · Asked 1×What are common mistakes engineers make when using database migrations?🟡 Medium · Conceptual · Asked 1×What are the main trade-offs of using stored procedures?🟡 Medium · Conceptual · Asked 1×What are the main trade-offs of using SQL Server?🟡 Medium · Conceptual · Asked 1×What is Redis, and what problem does it solve?🟢 Easy · Conceptual · Asked 1×How would you test a component that depends on Elasticsearch?🟡 Medium · Conceptual · Asked 1×How would you compare Cassandra and Snowflake for a production system?🔴 Hard · Conceptual · Asked 1×How can you improve the performance of a system that uses Redshift?🟡 Medium · Conceptual · Asked 1×What are the main trade-offs of using primary keys?🟡 Medium · Conceptual · Asked 1×How would you compare B-tree indexes and hash indexes for a production system?🔴 Hard · Conceptual · Asked 1×How can you improve the performance of a system that uses query execution plans?🟡 Medium · Conceptual · Asked 1×What is the difference between window functions and GROUP BY, and when would you use each?🟢 Easy · Conceptual · Asked 1×How would you troubleshoot a problem involving locks?🟡 Medium · Debugging · Asked 1×How would you migrate an existing system to constraints safely?🔴 Hard · System Design · Asked 1×Which configuration choices matter most for views?🟡 Medium · Conceptual · Asked 1×How would you monitor and alert on failures involving MySQL?🟡 Medium · Conceptual · Asked 1×How should a system using B-tree be designed for high load or concurrency?🔴 Hard · System Design · Asked 1×Which configuration choices matter most for B-tree?🟡 Medium · Conceptual · Asked 1×What follow-up could reveal whether a candidate really understands vacuum?🟡 Medium · Conceptual · Asked 1×What follow-up could reveal whether a candidate really understands logical?🟡 Medium · Conceptual · Asked 1×Explain the role of read in production systems.🟢 Easy · Conceptual · Asked 1×How would you troubleshoot a problem involving replicas?🟡 Medium · Debugging · Asked 1×What would you inspect first when replicas is slow or unstable?🟡 Medium · Debugging · Asked 1×What benefits and trade-offs come with window?🟡 Medium · Conceptual · Asked 1×How would you design for failure recovery around recursive?🔴 Hard · System Design · Asked 1×How would you troubleshoot a problem involving indexes?🟡 Medium · Debugging · Asked 1×How would you migrate an existing system to indexes safely?🔴 Hard · System Design · Asked 1×What metrics would you monitor for execution?🟡 Medium · Conceptual · Asked 1×How does primary keys work at a high level?🟡 Medium · Conceptual · Asked 1×How does unique constraints affect reliability or scalability?🟡 Medium · Conceptual · Asked 1×What are common mistakes engineers make when using composite indexes?🟡 Medium · Conceptual · Asked 1×How would you test a component that depends on composite indexes?🟡 Medium · Conceptual · Asked 1×What is query execution plans, and what problem does it solve?🟢 Easy · Conceptual · Asked 1×How can you improve the performance of a system that uses self joins?🟡 Medium · Conceptual · Asked 1×What are common mistakes engineers make when using GROUP BY?🟡 Medium · Conceptual · Asked 1×How would you troubleshoot a problem involving HAVING?🟡 Medium · Debugging · Asked 1×How does HAVING affect reliability or scalability?🟡 Medium · Conceptual · Asked 1×How can you improve the performance of a system that uses transactions?🟡 Medium · Conceptual · Asked 1×What is deadlocks, and what problem does it solve?🟢 Easy · Conceptual · Asked 1×How does levels compare with a common alternative?🟡 Medium · Conceptual · Asked 1×Explain the role of normalization in production systems.🟢 Easy · Conceptual · Asked 1×How would you implement or configure normalization in a production environment?🟡 Medium · Coding · Asked 1×What security considerations apply to planner?🔴 Hard · Conceptual · Asked 1×What benefits and trade-offs come with analyze?🟡 Medium · Conceptual · Asked 1×How would you implement or configure logical in a production environment?🟡 Medium · Coding · Asked 1×What would you inspect first when logical is slow or unstable?🟡 Medium · Debugging · Asked 1×What would you inspect first when read is slow or unstable?🟡 Medium · Debugging · Asked 1×When is joins a poor choice for a production system?🟡 Medium · Conceptual · Asked 1×How would you test a production implementation that uses subqueries?🟡 Medium · Other · Asked 1×What are common mistakes when using indexes?🟡 Medium · Debugging · Asked 1×How would you monitor and alert on failures involving plans?🟡 Medium · Conceptual · Asked 1×How would you document a production design that uses plans?🟡 Medium · Behavioral · Asked 1×How would you troubleshoot a problem involving pooling?🟡 Medium · Debugging · Asked 1×How would you troubleshoot a problem involving relational databases?🟡 Medium · Debugging · Asked 1×How would you troubleshoot a problem involving covering indexes?🟡 Medium · Debugging · Asked 1×What are the main trade-offs of using subqueries?🟡 Medium · Conceptual · Asked 1×How would you compare recursive CTEs and window functions for a production system?🔴 Hard · Conceptual · Asked 1×How would you troubleshoot a problem involving deadlocks?🟡 Medium · Debugging · Asked 1×How does database migrations work at a high level?🟡 Medium · Conceptual · Asked 1×How would you compare database migrations and schema versioning for a production system?🔴 Hard · Conceptual · Asked 1×What are common mistakes engineers make when using stored procedures?🟡 Medium · Conceptual · Asked 1×How would you test a component that depends on MariaDB?🟡 Medium · Conceptual · Asked 1×How does pooling compare with a common alternative?🟡 Medium · Conceptual · Asked 1×What are common mistakes when using window?🟡 Medium · Debugging · Asked 1×How would you document a production design that uses MySQL?🟡 Medium · Behavioral · Asked 1×What are common mistakes when using PostgreSQL?🟡 Medium · Debugging · Asked 1×When is PostgreSQL a poor choice for a production system?🟡 Medium · Conceptual · Asked 1×How would you optimize a system that depends on ANALYZE?🟡 Medium · System Design · Asked 1×What are common mistakes when using planner?🟡 Medium · Debugging · Asked 1×Describe a realistic interview scenario where analyze would be useful.🟡 Medium · Conceptual · Asked 1×How would you explain the trade-off between correctness and performance when using replication?🟢 Easy · Conceptual · Asked 1×How does replicas compare with a common alternative?🟡 Medium · Conceptual · Asked 1×Explain the role of joins in production systems.🟢 Easy · Conceptual · Asked 1×What would you inspect first when joins is slow or unstable?🟡 Medium · Debugging · Asked 1×How would you test a production implementation that uses window?🟡 Medium · Other · Asked 1×What are common mistakes when using CTE?🟡 Medium · Debugging · Asked 1×When would you use recursive, and when would you choose an alternative?🟡 Medium · Conceptual · Asked 1×Which configuration choices matter most for isolation?🟡 Medium · Conceptual · Asked 1×How would you document a production design that uses levels?🟡 Medium · Behavioral · Asked 1×How would you optimize a system that depends on normalization?🟡 Medium · System Design · Asked 1×How would you document a production design that uses denormalization?🟡 Medium · Behavioral · Asked 1×How would you monitor and alert on failures involving views?🟡 Medium · Conceptual · Asked 1×How would you document a production design that uses B-tree?🟡 Medium · Behavioral · Asked 1×What security considerations apply to EXPLAIN?🔴 Hard · Conceptual · Asked 1×How should a system using ANALYZE be designed for high load or concurrency?🔴 Hard · System Design · Asked 1×Describe a realistic interview scenario where read would be useful.🟡 Medium · Conceptual · Asked 1×How would you test a component that depends on normalization?🟡 Medium · Conceptual · Asked 1×How does partitioning work at a high level?🟡 Medium · Conceptual · Asked 1×How does read replicas work at a high level?🟡 Medium · Conceptual · Asked 1×How can you improve the performance of a system that uses triggers?🟡 Medium · Conceptual · Asked 1×What is the difference between materialized views and MySQL, and when would you use each?🟢 Easy · Conceptual · Asked 1×When would you choose PostgreSQL in a real project?🟡 Medium · Conceptual · Asked 1×What is the difference between Elasticsearch and DynamoDB, and when would you use each?🟢 Easy · Conceptual · Asked 1×How would you test a component that depends on Snowflake?🟡 Medium · Conceptual · Asked 1×How would you compare primary keys and foreign keys for a production system?🔴 Hard · Conceptual · Asked 1×What are common mistakes engineers make when using hash indexes?🟡 Medium · Conceptual · Asked 1×When would you choose query optimization in a real project?🟡 Medium · Conceptual · Asked 1×How can you improve the performance of a system that uses anti joins?🟡 Medium · Conceptual · Asked 1×How does HAVING work at a high level?🟡 Medium · Conceptual · Asked 1×What are the main trade-offs of using HAVING?🟡 Medium · Conceptual · Asked 1×How would you compare MVCC and deadlocks for a production system?🔴 Hard · Conceptual · Asked 1×Why is the use of connection important in production?🟢 Easy · Conceptual · Asked 1×How would you optimize a system that depends on pooling?🟡 Medium · System Design · Asked 1×Which configuration choices matter most for levels?🟡 Medium · Conceptual · Asked 1×How should a system using normalization be designed for high load or concurrency?🔴 Hard · System Design · Asked 1×Which configuration choices matter most for normalization?🟡 Medium · Conceptual · Asked 1×How would you troubleshoot a problem involving ANALYZE?🟡 Medium · Debugging · Asked 1×How would you monitor and alert on failures involving query?🟡 Medium · Conceptual · Asked 1×How would you test a production implementation that uses planner?🟡 Medium · Other · Asked 1×What edge cases should an interviewer ask about for joins?🟡 Medium · Conceptual · Asked 1×How would you optimize a system that depends on window?🟡 Medium · System Design · Asked 1×How is recursive typically used in a real system?🟡 Medium · Conceptual · Asked 1×How does recursive compare with a common alternative?🟡 Medium · Conceptual · Asked 1×When would you use execution, and when would you choose an alternative?🟡 Medium · Conceptual · Asked 1×How would you document a production design that uses execution?🟡 Medium · Behavioral · Asked 1×How does relational databases work at a high level?🟡 Medium · Conceptual · Asked 1×When would you choose recursive CTEs in a real project?🟡 Medium · Conceptual · Asked 1×How does window functions work at a high level?🟡 Medium · Conceptual · Asked 1×When would you choose window functions in a real project?🟡 Medium · Conceptual · Asked 1×How does pessimistic locking affect reliability or scalability?🟡 Medium · Conceptual · Asked 1×How does normalization affect reliability or scalability?🟡 Medium · Conceptual · Asked 1×What is the difference between database migrations and schema versioning, and when would you use each?🟢 Easy · Conceptual · Asked 1×How can you improve the performance of a system that uses MySQL?🟡 Medium · Conceptual · Asked 1×How would you troubleshoot a problem involving Elasticsearch?🟡 Medium · Debugging · Asked 1×What is SQL injection, and what problem does it solve?🟢 Easy · Conceptual · Asked 1×

🎤 Get Databases Sql questions answered in real-time

Assisting AI listens to your interview, captures questions live, and gives you instant AI-powered answers on a discreet on-screen overlay.

Get Assisting AI — Starts at ₹500

Browse Other Topics

Devops (2903) Ai Machine Learning (2177) Cloud Devops (2007) Data Engineering (1698) Algorithms Data Structures (1411) Frontend (1233) Python (1180) Javascript Typescript (1178) Java (1172) Backend Apis (1054) Security (794) System Design (791) Php (766) Behavioral (420) Testing (419) Data Science (417) Streaming (417) Systems Networking (416) Databases Nosql (416) Big Data Spark (416) Mobile (416) Go (416) Rust (416) Software Engineering (416)