|
Question |
Rating |
View Answer |
|
Before a user can build reports using Report Builder in Reporting Services 2005, which one of the following steps must be done first? |
|
View Answer |
|
What are DTS subroutines? What is their use and How do you write them? |
|
View Answer |
|
How are modified extents tracked in SQL Server 2005 (which internal structures)? |
|
View Answer |
|
What the heck does ATN2 do? |
|
View Answer |
|
You have two Service Broker instances running. One is on SQL1 with the default collation and the other is on SQL2 setup for French collation. Which collation is used for Service Broker messages sent between the instances? |
|
View Answer |
|
What is the difference between Inner join and full outer join in terms of the Number of rows return |
|
View Answer |
|
You setup a linked server from a SQL Server 2000 server to your new SQL Server 2005 server (with defaults), however you cannot execute procedures on the 2005 server. Why not? |
|
View Answer |
|
What are the three possible functions of the plus (+) operator in SQL Server 2005, the base installed T-SQL? |
|
View Answer |
|
What is a dirty page and dirty report? |
|
View Answer |
|
Which of the following is the best use for a Scalable Shared Database in SQL Server 2005? |
|
View Answer |
|
True or false, Report Builder supports using the LIKE function inside filters? |
|
View Answer |
|
What does @@textsize return? |
|
View Answer |
|
What does this return? select (1324 & 1024) |
|
View Answer |
|
How does a differential backup know which extents have changed so that it can be very quickly run? |
|
View Answer |
|
Which utility is used to administer SQL Server 2005 Notification Services instances? |
|
View Answer |
|
What does the Queue Reader Agent do in SQL Server 2005 replication? |
|
View Answer |
|
Which protocols support Kerberos authentication on SQL Server 2005? |
|
View Answer |
|
What does the DEALLOCATE statement do in SQL Server 2005? |
|
View Answer |
|
Error severity 13 indicates what? |
|
View Answer |
|
You have a Scalable Shared Database setup for reporting purposes on SQL2. You want to be able to keep a point in time view of the reporting database each month. What can you do? |
|
View Answer |