DBA / Database

What databases are created by default when initializing a PostgreSQL cluster?

What is the default transaction isolation level in Oracle?

What is the difference between Always On Availability Groups and regular replication?

What is the difference between VACUUM, VACUUM FULL, and autovacuum?

What is the difference between logical and physical backup? When should each be used?

The difference between dynamic and static SQL, advantages and disadvantages of dynamic SQL

If a transaction is rolled back, will the log table record made via a regular INSERT be preserved?

Translate the sentence: 'It didn't help yesterday' (Past Simple)

What are the transaction isolation levels in Oracle? Which is the default? What is the difference between READ COMMITTED and SERIALIZABLE?

How have you used data encryption? In what situations and for what data?

What is autovacuum in PostgreSQL and why is it needed?

How to configure master node selection in Patroni if one node is weaker and should not become primary?

How did you handle deadlocks in a high-load system? What did you do when they were detected?

What is DBLink? How have you used it? Architectural solutions?

What happens to a request during a leader restart in Patroni?

Is a cluster used separately from Availability Groups in practice?

Middle+

Иннотех

What types of indexes do you know in PostgreSQL? Tell about B-tree indexes.

What are hints in Oracle? Have you used any?

What monitoring tools for PostgreSQL do you know and have used?

What types of indexes do you know in MS SQL Server? Tell about clustered and non-clustered indexes.