|
Question |
Rating |
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 do I submit a form or a part of a form without a page refresh? |
|
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 |
|
How does a differential backup know which extents have changed so that it can be very quickly run? |
|
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 |
|
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 |
|
Where does Profiler store its temporary data in SQL Server 2005? |
|
View Answer |
|
What does this return? select (1324 & 1024) |
|
View Answer |
|
What does the Log Reader agent in SQL Server 2005 replication do? |
|
View Answer |
|
What is the difference between the full, simple and bulk log recovery models? |
|
View Answer |
|
What is a transaction isolation level and What is the advantage of it? What are different options that we set for a transaction isolation level? Transaction isolation levels are used when we go for transactions in stored procedures used in Transact SQL. |
|
View Answer |
|
What are DTS subroutines? What is their use and How do you write them? |
|
View Answer |
|
What is DESCRIBE command in SQL Server?What is its purpose?How to use it? |
|
View Answer |
|
How will you copy the structure of a table without copying the data? |
|
View Answer |
|
What is the difference between "procedure" and "function"? |
|
View Answer |