Using Reporting Services 2005, it is true or fal

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

(Continued from previous question...)

Using Reporting Services 2005, it is true or false that subreports execute a query against the datasource once for every detail row in the report?

Answer
True

Explanation
True. Subreports can be used for a master-detail relationship, or the subreport can be a separate item, but in either case RS will query to get the data for the report once for each detail row. If end users are going to only occasionally look at the data you're displaying in the subreport or only view it for a few rows, a better option is to create a link to the other report.

(Continued on next question...)

Other Job Interview Questions

• You have a relatively new SQL Server 2005 and msdb is corrupt. How can you fix this database without a restore? (data loss is acceptable)
• What is the recommended way to send mail from SQLAgent in SQL Server 2005?
• 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?
• You are looking to import a large amount of data from a remote OLEDB data source that is not a text file. Which of the following techniques can you use?
• In the Windows world, if you hit the "Enter" key on your keyboard between two single quotes and inserted this value, what data would be stored in the column?
• What port do you need to open on your server firewall to enable named pipes connections?
• What does the PAD_INDEX parameter do when you create an index in SQL Server 2005?
• You are looking to import a large amount of data from a remote OLEDB data source that is not a text file. Which of the following techniques can you use?
• The nesting level for stored procedures in SQL Server 2005, but how many databases can you access inside one stored procedure?
• Clicking File, Save in Report Builder does which of the following?
• More...