There are two types of subscriptions in SQL Serv

More DBA job interview questions and answers at http://dba.fyicenter.com/Interview-Questions/

(Continued from previous question...)

There are two types of subscriptions in SQL Server replication. What are they?

Answer
Push/Pull
Explanation
The two types of subscriptions are push and pull.

(Continued on next question...)

Other Job Interview Questions

• What is the quickest way to get them working?
• You have just upgraded your server from a single processor by adding 3 additional processors....
• You are wondering if your indexing scheme for the SQL Server 2005 database that you are managing is appropriate?
• What does this WHERE clause evaluate to?
• SELECT USER_NAME() -- Returns Andy
• How can you easily monitor to see if this assembly is being used?
• You want to script the execution of an Integration Services package from the command line for use from a Unix scheduler. What utility would you use?
• How many of these servers can you consolidate?
• What does VARP() do in SQL Server 2005?
• How can SQL Server Agent Mail send messages in SQL Server 2005?
• More...