Question 16 :
Which of the following modules within SQL Server 2005 cannot be signed with a digital signature?
DDL triggers cannot be signed, but all the other objects can.
Question 17 :
What does this return?
declare @i int
select @i = -5
This will return -5 as the result. The + operator functions as a unary plus operator, which means that it performs no operation on the value it preceeds.
Question 18 :
You have installed a US English SQL Server 2000 instance with the default options, collation, and sorting. What does this return:
create table MyTable
( Mychar varchar(20))
insert Mytable select 'Apple'
insert Mytable select 'ant'
insert Mytable select 'Ball'
select * from MyTable where Mychar like '[^a]%'
This should return "Ball" only since the ^ operator means not matching the next character. In this case, the first character should not be an "A".
Question 19 :
Where does Profiler store its temporary data in SQL Server 2005?
In the directory stored in the system variable TEMP.
Profiler uses the location specified for the TEMP system variable.
Question 20 :
What is the Service Broker Identifier ?
A GUID that identifies the database on which Service Broker is running.
Each database has a Service Broker identifier. This is a GUID in the service_broker_GUID column that identifies the databases on which Service Broker is running. It ensure that messages are delivered to the right database.