DBA > Job Interview Questions > Microsoft SQL Server FAQs

What type of update did you perform?

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

(Continued from previous question...)

What type of update did you perform?

You are performing an update of your Scalable Shared Database and receive note that two reports run at the same time received different results. These reports were both run during your update. What type of update did you perform?

Answer
A rolling update

Explanation
When performing a rolling update, doing the detach and attach on each server as opposed to detaching from all then attaching to all, it is possible that different reporting servers will display different results.

(Continued on next question...)

Other Job Interview Questions