What are the three possible functions of the plu

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

(Continued from previous question...)

What are the three possible functions of the plus (+) operator in SQL Server 2005, the base installed T-SQL?

Answer
Add, string concatenation, unary plus
Explanation
The three functions are Add, String Concatenation, and Unary Plus.

(Continued on next question...)

Other Job Interview Questions

• How does a differential backup know which extents have changed so that it can be very quickly run?
• Which of the following CREATE ASSEMBLY statement WITH PERMISSION_SET clauses sets ...
• What is the scope of the control permission in SQL Server 2005?
• What is the result of the following query?
• You want to disable the trigger dEmployee on the HumanResources...
• In configuring the thesaurus configuration file for SQL Server 2005 Full-Text Search, you set the diacritics_sensitive value to 1. What does this mean?
• Which index rebuild operation in SQL Server 2005 can be performed online?
• You are looking to secure your publisher to prevent unauthorized logins from accessing the data through replication. Where do you add the list of logins that have access?
• In SQL Server 2005 Integration Services, if you want to import a flat file very quickly that contains only integer data, what type of parsing should you use?
• What is the timestamp datatype used for?
• More...