Why use PreparedStatements over Statements in JDBC?
What does setting auto-commit to false in JDBC transactions do?
What does an index in a database mainly do?
Why do indexes slow down write operations?
How can EXPLAIN be used to understand a query's execution plan?
When might it be counterproductive to use an index?
How would you explain a common mistake when using indexes in an interview?
What design consideration should be made for heavily searched columns?
How can you balance the read and write performance in a database?
How would you explain a sequential scan in SQL in an interview?