Interview Practice Questions

Compare B-tree and Hash indexes. When should each be used?

What is JOIN and what are the main differences between INNER JOIN and LEFT JOIN?

Explain the CAP theorem and how it applies to distributed database systems.

How does sharding work and what problems does it help to solve?

What is pub/sub in Redis and what are its main advantages?

What are the main differences between normalization and denormalization in the context of data modeling?

What is a B-tree index and how does it work?

Explain the difference between JOIN and SUBQUERY.

What is ACID and why is it important for transactions?

When should you use a CTE instead of a subquery?

Explain how a window function works and provide an example of its use.

What is replication and what types exist?

Compare BASE and ACID. In what scenarios is it better to use each model?

Explain how partitioning works in PostgreSQL.

What is the difference between data normalization and denormalization, and when should each be applied?

What would you do if a JOIN operation in a distributed database took too long?

Modify the query: an anomaly is defined as three times the average over the two preceding and two following days, excluding the day itself.

Что посмотреть надо, что проверить надо, что дополнительно запросить надо?

Why кстати из таблицы table1? Где у них не будет?

Может ли быть у тебя тут такое, что левый индекс обгонит правый?