True or false, Report Builder supports using the

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

(Continued from previous question...)

True or false, Report Builder supports using the LIKE function inside filters?

Answer
False

Explanation
There is no LIKE support, the next best thing is the CONTAINS function which works as if you specified both a leading and trailing wild card.

(Continued on next question...)

Other Job Interview Questions

• What is the difference between a return parameter and an OUTPUT parameter?
• In SQL Server 2005, can you include a user-defined role as a member of another user-defined role?
• In SQL Server 2005 T-SQL, what does the CONTINUE statement do?
• When you create a new Message Type in the SQL Server 2005 Service Broker, what does the Authorization parameter signify?
• 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?
• You cannot execute procedures on the 2005 server. Why not?
• Which database holds the tables that Database Mail uses to store mail messages and other data in SQL Server 2005?
• What does the DUMP command do?
• Clicking File, Save in Report Builder does which of the following?
• For regulatory reasons, you must maintain an exact text copy of your XML documents in your SQL Server 2005 database. What datatype of storage should you choose?
• More...