Interview Practice Questions

Do you program in Python?

Do you know the difference between threads and processes?

Про PIP-8, Linting, MyPy. Знаком с ними, работал когда-нибудь?

Первый вопрос. Какие из перечисленных типов питона являются неизменяемыми?

Я очень извиняюсь. А Why каунтер не сможет уйти в минус?

Если мы хотим проверить на какой мы ветки, вообще какие изменения сейчас есть?

What is a JOIN in SQL and what types of JOINs exist?

Explain the differences between GROUP BY and HAVING.

What are indexes and how do they work in PostgreSQL?

Explain what a CTE is and when it should be used.

How does the MVCC mechanism work in PostgreSQL?

Compare ACID and BASE. In what scenarios should each model be used?

When should subqueries be used instead of JOINs?

What is a deadlock and how can it be avoided in transactions?

How does sharding work in NoSQL databases?

Explain how ClickHouse works and how it differs from relational databases.

What are indexes in databases and how do they work?

What is a subquery and how does it differ from a regular query?

Explain the difference between HAVING and WHERE in SQL.

How do window functions work in SQL and when should they be used?