Set - 1

Question 11 :

How many rows are returned by these two select statements?

Answer :

2 and 2
Each select statement actually returns 2 rows. You can use this script to check this:
create table mytable
( id int identity(1,1)
, mychar varchar(20)
)
go
insert mytable select null
insert mytable select ''
insert mytable select ' '
go
set ansi_nulls on
set ansi_null_dflt_on on
select * from mytable
where mychar is not null
select * from mytable
where mychar <> '' and mychar is not null
select * from mytable
where mychar <> ' ' and mychar is not null
select * from mytable where mychar = ''
select * from mytable where mychar = ' '
set ansi_null_dflt_on off
set ansi_nulls off
go
drop table mytable


Question 12 :

What does the Queue Reader Agent do in SQL Server 2005 replication?

Answer :

This agent reads the subscriber logs and moves changes back to the publisher.
This agent is used when the queued update model is chosen with transactional replication. It moves changes from the subscribers back to the publishers.


Question 13 :

What are the three possible functions of the plus (+) operator in SQL Server 2005, the base installed T-SQL?

Answer :

Add, string concatenation, unary plus
The three functions are Add, String Concatenation, and Unary Plus.


Question 14 :

The Sort component in SQL Server 2005 Integration Services is what type of component?

Answer :

Blocking Transformation
The Sort component is a blocking transformation meaning that it needs all rows in order to perform its function.


Question 15 :

If you received a "Performance Critical" status in the SQL Server 2005 replication monitor, what does this mean?

Answer :

The latency between transaction commits at the publisher and subscriber exceeds the warning level.
This status can actually mean two different things. Either the latency between the commit of a transaction at the publisher and the same commit at the subscriber is exceeding some level in a transactional level or not enough rows are being processed in a merge replication scenario.