You want to be sure your database server if prop

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

(Continued from previous question...)

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?

Answer
1433 and a specific port after configuring the named instance to use that specific port
Explanation
Named instances must be configured to use a specific port and that port then opened in the firewall.

(Continued on next question...)

Other Job Interview Questions

• What does a return value of -1 mean from the function XACT_STATE() in SQL Server 2005?
• You are building a .NET assembly that will access the registry of the local machine for a factor used in a computer column. What permission set should you assign it?
• In SQL Server 2005, which of the following schema changes are supported for the publication objects of a replicated database?
• If you received a "Performance Critical" status in the SQL Server 2005 replication monitor, what does this mean?
• You want to speed up your SQL Server 2005 Service Broker queue by placing an index on it. What is the best way to do this?
• How many users can be added to an application role in SQL Server 2005?
• Which of the following is not available to you?
• How can you quickly determine if any of these indexes are really being used?
• Which of the following is not true about the Raw File Destintion connection in SQL Server 2005 Integration Services?
• What is the best way to have your junior DBA do this?
• More...