Role preparation
Database and SQL Developer interview questions and answers.
Query performance, indexes, and transaction safety.
Questions
Technical questions to practise out loud
- 01
How do composite indexes work?
Show practical understanding of column order, leftmost prefixes, and query access paths.
Read the full breakdown - 02
How do you read a query execution plan?
Show practical understanding of scans, joins, cardinality estimates, and bottlenecks.
Read the full breakdown - 03
How do locks and transactions affect database concurrency?
Show practical understanding of isolation, lock scope, deadlocks, and consistency.
Read the full breakdown - 04
When do you normalise or denormalise data?
Show practical understanding of when do you normalise or denormalise data?.
Read the full breakdown - 05
How does database replication affect design?
Show practical understanding of how does database replication affect design?.
Read the full breakdown - 06
How do you investigate a database deadlock?
Show practical understanding of how do you investigate a database deadlock?.
Read the full breakdown - 07
How do you validate database backups?
Show practical understanding of how do you validate database backups?.
Read the full breakdown - 08
When do you consider database sharding?
Show practical understanding of when do you consider database sharding?.
Read the full breakdown - 09
How do you secure database access?
Show practical understanding of how do you secure database access?.
Read the full breakdown - 10
How do you paginate large SQL result sets?
Show practical understanding of how do you paginate large sql result sets?.
Read the full breakdown