DBA / Database

Tell me about bitmap, function-based, and reverse key indexes — what are they?

How does database recovery work from full + differential + transaction log backups?

Have you ever had cases of upgrading the database product version? How did you prepare and what problems arose?

Translate: 'Are you specialized in this field?'

What types of JOINs could you see in the execution plan? In what situations are they used?

Translate the sentence: 'Это не помогает сейчас' (negative form of Present Continuous).

Have you worked with Execution Plan? What metrics do you look at and how do you decide on indexes?

Middle+

Иннотех

Do you know about the pg_repack extension? How does it help with the VACUUM FULL problem?

What types of indexes are there in Oracle and which ones have you used?

Task 4: Optimize the query WHERE DATE(tep.available_from_departure_date) = departureDate. Explain the problem and suggest a solution.

Как происходит failover в AlwaysOn — ручной и автоматический? Что такое Availability Group?

Middle+

Иннотех

If the trigger is BEFORE INSERT, will the result of its operation be saved if the procedure is rolled back?

How did you ensure the security of your data? What methods did you use?

What types of database queries do we have?

If an index is not used in a SELECT query, how do you determine the reason and what actions do you take?

What is the difference between TRUNCATE and DELETE?

Tell me more about database security: users, logins, permissions — what did you do at the user level?

How many clustered indexes can be on a single table and why?

What is the purpose of statistics in DBMS?

What PostgreSQL utilities do you know and have used?