|
Related Questions |
View Answer |
|
You accidently delete an application from an instance of SQL Server 2005 Notification Services. However you have not removed the database, nor the application objects. Can you re-associate the application with the same SSNS instance?
|
View Answer
|
|
Can a particular event in SQL Server 2005, such as the CREATE USER command, have more than one DDL trigger assigned to it?
|
View Answer
|
|
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?
|
View Answer
|
|
After you've completed a backup for your Sales server to disk, you want to be sure that this backup is intact and able to be used for restores before writing it to tape. What command will help you here?
|
View Answer
|
|
Which utility is used to administer SQL Server 2005 Notification Services instances?
|
View Answer
|
|
You have noticed in both your SQL Server 2000 and 2005 instances that when a database grows in SQL Server, there is a delay in the database response. Why is that?
|
View Answer
|
|
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?
|
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
|