Appearance

Sidebar Navigation

Overview

SQL

All SQL

What is SQL?

What is the difference between INNER and LEFT JOIN?

How do GROUP BY and HAVING differ?

What is a database index?

How do transactions work?

What are isolation levels?

What is normalization?

How do you prevent SQL injection?

How do you optimize a slow SQL query?

What are window functions?

PostgreSQL

All PostgreSQL

What makes PostgreSQL different from other relational databases?

What is MVCC in PostgreSQL?

How do PostgreSQL indexes work?

What is VACUUM?

How do you use EXPLAIN ANALYZE?

What are JSONB columns useful for?

How do PostgreSQL transactions and locks work?

What are common table expressions?

How do you configure replication?

How do you back up and restore PostgreSQL?

MongoDB

All MongoDB

What is MongoDB?

When should you embed versus reference documents?

How do MongoDB indexes work?

What is the aggregation pipeline?

How do MongoDB transactions work?

How do you model relationships in MongoDB?

What is a replica set?

What is sharding?

How do you optimize a MongoDB query?

How do you secure MongoDB?

Redis

All Redis

What is Redis?

What data structures does Redis provide?

When should you use Redis as a cache?

How do cache-aside and write-through caching differ?

How do Redis expiration and eviction work?

What is Redis persistence?

How do you prevent cache stampedes?

What are Redis transactions?

How does Redis Pub/Sub work?

How do Redis Cluster and Sentinel differ?

On this page

SQL

Browse questions in this section. Start here.

Pager

Previous pageOverview

Next pageWhat is SQL?

Built for developers preparing for technical interviews. · About us · Contact us · Privacy policy · Terms & conditions

SQL ​

SQL