In a new default SQL Server 2005 installation, w

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

(Continued from previous question...)

In a new default SQL Server 2005 installation, what is the status of the dedicated administrator connection?

Answer
Enabled for local connections only.
Explanation
The dedicated adminstrator connection is enabled for local connections only by default.

(Continued on next question...)

Other Job Interview Questions

• What T-SQL function can achieve this?
• On which platforms can you use Instant File Initialization to improve database growth performance in SQL Server 2005?
• In SSIS, what is the difference between output columns and external columns?
• What does a @@fetch_status of -2 mean in SQL Server 2005?
• What result would you expect from this statement? Select * from dbo .MyTable
• What is the best way to have your junior DBA do this?
• How many of these servers can you consolidate?
• Using Reporting Services 2005, it is true or false that subreports execute a query against the datasource once for every detail row in the report?
• Which severity levels of errors can be corrected by a user (as opposed to those that an administrator or Microsoft must work to fix.)
• Which optional SQL Server component must you install to ensure that you can create and execute maintenance plans?
• More...