|
INTERVIEW QUESTIONS
DATABASE
SQL SERVER
DETAILS
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 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.
|
|
|
Category |
SQL Server Interview Questions & Answers -
Exam Mode /
Learning Mode
|
Rating |
(0.2) By 9108 users |
Added on |
9/14/2014 |
Views |
68838 |
Rate it! |
|
|
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 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. Source: CoolInterview.com
If you have the better answer, then send it to us. We will display your answer after the approval.
Rules to Post Answers in CoolInterview.com:-
- There should not be any Spelling Mistakes.
- There should not be any Gramatical Errors.
- Answers must not contain any bad words.
- Answers should not be the repeat of same answer, already approved.
- Answer should be complete in itself.
|
|
Related Questions |
View Answer |
|
You have created a database snapshot on SQL Server 2005 for the sales database to capture the end-of-month activity. The next day your server fails and you need to recover to a standby server using the previous night's backups. How do you recover the snapshot?
|
View Answer
|
|
On which platforms can you use Instant File Initialization to improve database growth performance in SQL Server 2005?
|
View Answer
|
|
You have a large table that you wish to partition to improve performance. The table contains many columns of data about customers and you decide that basic information about each customer will remain in the current table. Extended information, such as shipping instructions, secretaries' names, etc. will be moved to a new table along with the PK. What type of partitioning is this?
|
View Answer
|
|
Which RAID levels store parity information?
|
View Answer
|
|
True or false, Report Builder supports using the LIKE function inside filters?
|
View Answer
|
|
Using Report Builder, which of the following statements is correct about formatting numbers?
|
View Answer
|
|
Which of the following choices show the three report formats supported by Report Builder ?
|
View Answer
|
|
Clicking File, Save in Report Builder does which of the following?
|
View Answer
|
|
What is the easiest way to capture the SQL statement for a Report Builder report you're troubleshooting?
|
View Answer
|
|
Using Report Builder, which of the following is the best statement about the formatting options for Boolean columns?
|
View Answer
|
|
When discussing image support in Report Builder, which of the following is the most accurate statement?
|
View Answer
|
|
True or false, Report Builder offers direct export to a Microsoft Access database as one of its supported export options?
|
View Answer
|
|
If you absolutely need a report to look the same regardless of what OS or viewing software is being used, which of the following file formats would be the best choice?
|
View Answer
|
|
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?
|
View Answer
|
|
True or false, Report Builder supports user defined run time parameters?
|
View Answer
|
|
Which of the following statements best describes the filter capabilities of Report Builder?
|
View Answer
|
|
What is the scale of measurement for the cost threshold for parallelism setting in SQL Server 2005?
|
View Answer
|
|
How can SQL Server Agent Mail send messages in SQL Server 2005?
|
View Answer
|
|
You are loading 100 rows of data into a narrow table that is heavily used by your production inventory queries. It was recommended that you drop the indexes on the table before the load and then rebuild them after the load is complete. Is this something you would do?
|
View Answer
|
|
Which of the following is the best use for a Scalable Shared Database in SQL Server 2005?
|
View Answer
|