In replication, what is each set of the source d

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

(Continued from previous question...)

In replication, what is each set of the source data that is replicated from the source server called?

Answer
Article
Explanation
Each set of source data that is replicated is called an article.

(Continued on next question...)

Other Job Interview Questions

• You want to be sure that your reporting solutions using a database snapshot are properly protected from disaster. How can you back up your database snapshots?
• Is it possible to build an index on a view
• You wish to prevent anyone from using the sa account on your SQL Server 2005 instance, but still keep it available if your polocy changes. What can you do?
• Which of these is not a parameter you can pass to the LOGINPROPERTY function?
• When discussing image support in Report Builder, which of the following is the most accurate statement?
• Which of the following is an invalid file name for a database file?
• With SQL Server 2005, Oracle servers can be included in your replication topology. How can an Oracle server function?
• You want to create a covering index for this query on your SQL Server 2005 database ...
• What can be used to ensure that a field in a table only accepts a certain range of values?
• What does the CREATE SERVICE statement do in SQL Server 2005?
• More...