Set - 3

Question 1 :

Which utility is used to administer SQL Server 2005 Notification Services instances?

Answer :

nscontrol.exe
The nscontrol application can be used with various parameters to administer a SQL Server 2005 Notification Services instance.


Question 2 :

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
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.


Question 3 :

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
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)


Question 4 :

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
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.


Question 5 :

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
An event can have multiple triggers assigned to it.