Set - 1

Question 6 :

What is the recommended way to send mail from SQLAgent in SQL Server 2005?

Answer :

Database Mail
You can use either Database Mail or SQLMail with SQL Agent in SQL Server 2005. However since SQLMail will be removed, it is recommended that you use Database Mail.

Question 7 :

When you create a new Message Type in the SQL Server 2005 Service Broker, what does the Authorization parameter signify?

Answer :

The owner of the message type.
This parameter determines the owner of the message type. This defaults to the current user.

Question 8 :

What the heck does ATN2 do?

Answer :

The angle between the x-axis and a ray.
This is a mathematical function that returns the angle between the positive x-axis and the ray that passes through the two coordinates passed in. The angle is in radians.

Question 9 :

How does a differential backup know which extents have changed so that it can be very quickly run?

Answer :

The DCM tracks changes. The differential backup reads the extents from this structure.
A differential backup uses the Differential Change Map to determine which extents have changed and need to be include in the backup. This greatly speeds the differential backup process.

Question 10 :

If you run this, what does it return?
select applock_mode('public', 'SalesApp', 'Transaction')

Answer :

The type of lock being held by an application that requested it.
This command returns the lock mode held by an application that was requested with the sp_getapplock procedure.

insert mytable select ''
insert mytable select ' '
select * from mytable where mychar = ''
select * from mytable where mychar = ' '