On which port does the dedicated administrator c

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

(Continued from previous question...)

On which port does the dedicated administrator connection listen in SQL Server 2005?

Answer: a Dynamic port assigned on server start.
Explanation: The port is assigned dynamically. You can get the port from the error log after SQL Server has started.

(Continued on next question...)

Other Job Interview Questions

• Which of the following is not available to you?
• How are modified extents tracked in SQL Server 2005 (which internal structures)?
• You are performing a number of SELECT queries on one of your SQL Server 2005 Service Broker queues and you get a call that applications using the queues are running slowly. What can you do?
• Which of the following is the best use for a Scalable Shared Database in SQL Server 2005?
• What is the difference between a return parameter and an OUTPUT parameter?
• Which of the following CREATE ASSEMBLY statement WITH PERMISSION_SET clauses sets ...
• You want to partition these past orders columns into a new table. What type of partitioning is this?
• If you run this, what does it return? select applock_mode('public', 'SalesApp', 'Transaction')
• You want to be sure your database server if properly secured. You have two instances, a default instance and a named instance installed. Which ports do you need to open?
• In SQL Server 2005 Full-Text Search, you set up a replacement set like this...
• More...