Which types of replication work with Oracle publ

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

(Continued from previous question...)

Which types of replication work with Oracle publishers?

Answer
Snapshot and transactional

Explanation
Oracle publishing with SQL Server works as both snapshot and transactional publication issues.

(Continued on next question...)

Other Job Interview Questions

• When the network service built-in account connects to a network resource, what is the context?
• When testing connectivity in SQL Server, you use which utility in conjunction with the readpipe utility to establish a connection?
• When declaring an XML document, which type allows text nodes at the top level?
• How many dimensions can you have in a SQL Server 2005 Analysis Services database?
• The Service Broker operates on messages in which fashion?
• What does a report model provide in SQL Server 2005 Reporting Services?
• 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?
• You want to disable the trigger dEmployee on the HumanResources...
• Which severity levels of errors can be corrected by a user (as opposed to those that an administrator or Microsoft must work to fix.)
• When you create a new Message Type in the SQL Server 2005 Service Broker, what does the Authorization parameter signify?
• More...