(Continued from previous part...)

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?

Answer
RESTORE VERIFYONLY

Explanation
After a backup file has been written to disk or tape, its integrity can be checked with the RESTORE VERIFYONLY command. This command will verufy the backup set is complete and that the files are readable.

What is the result of the following query?
declare @a int
declare @b int

set @a = 5
set @b = 11

select @a = @a ^ @b , @b = @b ^ @a, @a = @a ^ @b
print '@a = '+convert(varchar,@a)
print '@b = '+convert(varchar,@b)

Answer
@a = 11 , @b = 5

Explanation
Here is the explanation:

Step 1
@a has the value of 5 and is binairy 101
@b has the value of 11 and is binairy 1011

After “select @a = @a ^ @b , @b = @b ^ @a, @a = @a ^ @b”
the values are
@a will get the value from 101 ^ 1011 = 1110 (=14)
@b have stil the value of 1011 (=11)

Step 2
After “select @a = @a ^ @b , @b = @b ^ @a, @a = @a ^ @b”
The values are
@a will stay at the value 1110 (=14)
@b will get the value from 1011 ^ 1110 = 101 (=5)

Step 3
After “select @a = @a ^ @b , @b = @b ^ @a, @a = @a ^ @b”

@a will get the value from 1110 ^ 101 = 1011 (=11)
@b will stay at the value 101 (=5)

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.

Can a particular event in SQL Server 2005, such as the CREATE USER command, have more than one DDL trigger assigned to it?

Answer
Yes
Explanation
An event can have multiple triggers assigned to it.

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?

Answer
No
Explanation
You cannot re-assocaite the application because when you add the application, SSNS recreates the objects. If they already exist, the create fails.

How many users can be added to an application role in SQL Server 2005?

Answer
None
Explanation
This is a trick questions. No users are added to application roles. Application roles are invoked by a user.

(Continued on next part...)