Thank you all for the inputs.  I thought that was a bit strange for an interview brain teaser. 

Pleasant day to all of you guys!

Thanks Frank,

This is an interview questions.  How would you answer this in the circumstances mention here?

For Locking problem, Find out the two SPID and try to understand what is the two transaction are doing and why did that happened.  Hints:  sp_who2 active and DBCC INPUTBUFFER...

It sound like a performance issue.  Once you identified the user spid and the query that he or she is running by using sp_who2 active and DBCC INPUTBUFFER performed the...

Check directory path of the target folder that specified to store db backup or tlog backup.  The directory path may contain "-S" string.  Do not use strings that contain "-S". ...

This can be done using DTS wizard (follow the instructions), however the user passwords will not be copy from server A to Server B.  You need to extract sysusers table...

Micro Soft advices that you should run DBCC Commands in a single user mode in SQL Server 7.0 and below because in SQL Server 7.0,DBCC CHECKDB statement get a...