Out of the box Report Builder supports two repor

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

(Continued from previous question...)

Out of the box Report Builder supports two report level fields that can be shown on a report. Which option below has those two options?

Answer
The current filter and the number of rows that matched that filter

Explanation
By default, the current filter definition and the number of rows that matched the filter are added to the end of the report. They can be removed and added back as needed.

(Continued on next question...)

Other Job Interview Questions

• Which of these options cannot be set in the SQL Server 2005 Integration Services Bulk Insert task?
• What is the quickest way to get them working?
• Using Report Builder that is bundled with Reporting Services 2005, which of the following would work as a way to add a derived field to a report?
• What can be used to ensure that a field in a table only accepts a certain range of values?
• On which port does the default instance of SQL Server 2005 Analysis Services listen to by default?
• You are writing a new stored procedure to perform maintenance on your SQL Server 2005 databases that defragments the indexes in an online manner. What command should you use?
• Which is these is not necessary for a well-formed XML document?
• 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?
• What message types exist in SQL Server 2005 Service Broker?
• Where does Profiler store its temporary data in SQL Server 2005?
• More...