DBA / Database

What is the difference between a regular cluster (Failover Cluster) and AlwaysOn Availability Groups?

Middle+

Иннотех

Have you worked with exceptions? What types of exceptions are there in PL/SQL?

You mentioned process optimization. What exactly did you do for that?

What types of backups do you know? What is the difference between them?

What types of data storage do you know for cloud and on-premise solutions?

Have you worked with PgBouncer or PgPool? What are they used for?

How do you rate yourself on the grade?

If a user only needs to execute a stored procedure and nothing else, what permissions should be granted to them?

Why is quorum needed in etcd for Patroni?

What is bloat (swelling) of tables and indexes? How to fight it?

Among the listed query types (SELECT, INSERT, UPDATE, DELETE), which ones speed up indexes and which ones slow them down?

Have you worked with replication topologies? Tell about your experience.

What is a replication slot and what is it used for?

What is a temporary table in SQL/PLSQL? Do you use temporary tables?

What are key columns and INCLUDE columns in an index? How to use them correctly?

Что такое TCL? Какие команды входят в TCL?

What monitoring tools have you used?

What is the purpose of the PRAGMA AUTONOMOUS_TRANSACTION directive?

Tell us about your experience with AWS and Azure cloud technologies. What tools have you used?

How do you differentiate between system and user exceptions? What is the difference in their usage?