DBA / Database

How do backups work in SQL Server (full, differential, transaction log)?

Tell me about your motivation — what is important to you now when choosing a new workplace?

Have you used audit or logging logic for procedures? How did you implement it?

Tell me about the architecture of MS SQL Server

Explain conceptually how indexes work in SQL. What types of database queries exist?

How to organize the architecture of a table that grows rapidly for fast operation only with fresh data? How to efficiently delete old data?

What happens to the cluster if quorum is not reached?.

What queries accelerate indexes and why?

What happens inside Oracle when executing a SELECT query (after pressing F8)?

Tell me about the All-in-one approach in the project: did you create it yourself, when was it used, how many were there?

Tell us about your experience migrating databases. What steps do you take during minor and major PostgreSQL updates?

Tell about packages in Oracle: package specification and body, differences, can one be without the other?

Tell about the steps of migrating a database from on-premise to cloud (AWS).

Have you worked with PgBarman or PgBackRest? Share your backup experience.

What is Query Store in SQL Server and where is it located?

What is DWH and what is it used for?

Describe the logical structure of DWH.

Tell us specifically what you do in your current job as a system analyst.

The report data does not match the source system. How will you act?

In DWH, order information is modeled as follows. fct_order - id - create_dt - cost - driver_id dim_driver - driver_id - name - phone How can the data model be improved to store information about multiple driver phones with their types (main, additional, emergency)?