DBA / Database

Translate the sentence: 'It helps now' (Present Continuous)

Discuss which of the developer problems from the video affect you personally (developer frustrations)

Determine the tense of the verb and fill in the blank: 'Why ___ he calling now? Is it urgent?'

Properties of transactions (ACID)

Have you worked with triggers? What did you use them for? What types of triggers do you know (ROW vs STATEMENT)?

Tell us about your experience creating and deleting indexes in PostgreSQL.

We have a SELECT query on a date column with a B-Tree index. The query runs slowly, and the plan shows that the index is not used. Why?

Why is VACUUM needed in PostgreSQL? Explain the difference between VACUUM and VACUUM FULL.

If the Postgres master has fallen and Patroni has switched it to a replica, how does the SQL server that pulls data from Postgres find out about this?

Explicit and implicit cursors — when are they used?

Tell me about partitioning in Oracle: what types are there and how have you used it?

What is quorum in Patroni and why is it needed?

Have you ever had to automate processes? How did you identify slow queries and how was the optimization carried out?

Explain the concept of normalization and its benefits.

Describe the three most common problems people face when working on projects (using learned collocations).

How to handle exceptions inside a trigger? Is it better to report the error or to silence it?

How to identify hanging transactions in PostgreSQL?

How would you build a disaster recovery plan and configure replication for a client with a small on-premise database?

Tell me about yourself.

Ответьте на вопрос: 'What don't you like about women?' (практика разговорных фраз из красного списка)