Interview Preparation

Database Engineer

Data modeling, SQL, indexing, transactions, performance and reliability.

Core skills

SQL

Data Modeling

Indexes

Transactions

Performance

Backup

Interview questions & answers

Practice role-specific questions with concise answers and key points.

2 published

FundamentalsBeginner

What is a transaction?

Answer: A transaction groups database operations into a unit with defined consistency guarantees, commonly described through atomicity, consistency, isolation and durability.

Atomicity
Isolation
Durability

PerformanceAdvanced

How would you investigate a slow database query?

Answer: Inspect the query plan, indexes, cardinality estimates, joins, filtering, locking and resource utilization; then change the highest-impact factor and measure again.

Query plan
Indexes
Measurement

Browse all interview questions

Loading AdmnWizard Hub…

← All roles