What the heck does ATN2 do?

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

(Continued from previous question...)

What the heck does ATN2 do?

Answer: The angle between the x-axis and a ray.

Explanation: This is a mathematical function that returns the angle between the positive x-axis and the ray that passes through the two coordinates passed in. The angle is in radians.

(Continued on next question...)

Other Job Interview Questions

• 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?
• Does a root element in an XML document necessarily contain all the content for a well-formed document?
• What security role should you assign them?
• Can a contained in SQL Server 2005 Integration Services enlist in a transaction started by a sibling container?
• What value should you use for the BROKER_INSTANCE parameter?
• What is the default type of XML data if you do not specify an arguement?
• What is the best way to have your junior DBA do this?
• Clicking File, Save in Report Builder does which of the following?
• True or false, Report Builder supports using the LIKE function inside filters?
• What does a return value of -1 mean from the function XACT_STATE() in SQL Server 2005?
• More...