|
Question |
Rating |
View Answer |
|
What is the difference between weak entity set & strong entity set? |
|
View Answer |
|
What is SQL Server ? |
|
View Answer |
|
Error severity 13 indicates what? |
|
View Answer |
|
In which order do you perform an upgrade to SQL Server 2005 for replicated databases? |
|
View Answer |
|
How many Service Packs will be released for SQL Server 2005 in 2007? |
|
View Answer |
|
You setup a linked server from a SQL Server 2000 server to your new SQL Server 2005 server (with defaults), however you cannot execute procedures on the 2005 server. Why not? |
|
View Answer |
|
What is the recommended way to send mail from SQLAgent in SQL Server 2005? |
|
View Answer |
|
When you create a new Message Type in the SQL Server 2005 Service Broker, what does the Authorization parameter signify? |
|
View Answer |
|
What the heck does ATN2 do? |
|
View Answer |
|
How does a differential backup know which extents have changed so that it can be very quickly run? |
|
View Answer |
|
If you run this, what does it return? select applock_mode('public', 'SalesApp', 'Transaction') |
|
View Answer |
|
How many rows are returned by these two select statements? |
|
View Answer |
|
What does the Queue Reader Agent do in SQL Server 2005 replication? |
|
View Answer |
|
What are the three possible functions of the plus (+) operator in SQL Server 2005, the base installed T-SQL? |
|
View Answer |
|
The Sort component in SQL Server 2005 Integration Services is what type of component? |
|
View Answer |
|
If you received a "Performance Critical" status in the SQL Server 2005 replication monitor, what does this mean? |
|
View Answer |
|
Which of the following modules within SQL Server 2005 cannot be signed with a digital signature? |
|
View Answer |
|
What does this return? declare @i int select @i = -5 select +@i |
|
View Answer |
|
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)) go insert Mytable select 'Apple' insert Mytable select 'ant' insert Mytable select 'Ball' go select * from MyTable where Mychar like '[^a]%' |
|
View Answer |
|
Where does Profiler store its temporary data in SQL Server 2005? |
|
View Answer |