In SQL Server 2005, which network protocols use

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

(Continued from previous question...)

In SQL Server 2005, which network protocols use endpoints?

Answer
All of the above

Explanation
All communication points with SQL Server using network protocols use an endpoint. SQL Server creates defaults for each protocol that you enable.

(Continued on next question...)

Other Job Interview Questions

• What does the PAD_INDEX parameter do when you create an index in SQL Server 2005?
• You are loading 100 rows of data into a narrow table that is heavily used by your production inventory queries...
• Which permission in SQL Server 2005 allows you to switch your security context to that of another user with the EXECUTE AS statement?
• In Full-Text Search, what is word breaking?
• What is a dialog conversation in the SQL Server 2005 Service Broker.
• What is the maximum number of instances of Analysis Services 2005 can be installed on a server?
• In a new default SQL Server 2005 installation, what is the status of the dedicated administrator connection?
• To optimize the configuration of tempdb for performance, what setting should be used for the tempdb recovery model?
• What rights does a user need to perform a truncate table command SQL Server 2005?
• What is the granularity in seconds of the timestamp datatype?
• More...