Set - 4

Question 21 :

Which of the following is not true about the Raw File Destintion connection in SQL Server 2005 Integration Services?

Answer :

It supports BLOB object data.
The Raw File Destination connection does not use a connection manager, supports NULL data, and only has one input. It also does not support BLOB data or have an error output.


Question 22 :

What message types exist in SQL Server 2005 Service Broker?

Answer :

These are defined for each contract.
Each application that sets up queues and contracts inside Service Broker must define the message types that are valid for the contract.


Question 23 :

What does the CEILING() function do?

Answer :

Returns the smallest integer greater than or equal to the value passed in.
CEILING() returns the smallest integer that is great than or equal to the value passed in.


Question 24 :

What is a dialog conversation in the SQL Server 2005 Service Broker.

Answer :

A dialog conversation is a conversation between services.
A dialog conversation is a conversation between services. A conversation includes messages being passed back and forth as part of a contract.


Question 25 :

What is row versioning in SQL Server 2005?

Answer :

Row versioning keeps a copy of each row for use by applications or transactions to prevent readers from being blocked by writers.
Row versioning is a method whereby the database engine keeps a copy of a row's data as it existed before the start of a transaction for queries to read this data and reduce locking contention if they are configured.