DBA > Job Interview Questions > Hiring the Best Database Administrator Questions and Answers

SQL Server - Explain when and how transactions s

More DBA job interview questions and answers at http://dba.fyicenter.com/Interview-Questions/

(Continued from previous question...)

SQL Server - Explain when and how transactions should be used.

Start with just that open-ended interview question, and if they have trouble getting started, give them a scenario.

“Say we’ve got a table for Orders, and a table for OrderDetails. Someone places an order for two books – Bacon: A Love Story and the hit bestseller Eat What You Want and Die Like A Man. Tell me what happens.”

After they’ve answered, ask them when transactions should not be used. We don’t want our developers wrapping anything inside a transaction unless it absolutely needs to be.

(Continued on next question...)

Other Job Interview Questions