With SQL Server 2005, Oracle servers can be incl

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

(Continued from previous question...)

With SQL Server 2005, Oracle servers can be included in your replication topology. How can an Oracle server function?

Answer: As a subscriber or publisher.

Explanation: Oracle can act as a publisher or subscriber, but not a distributor.

(Continued on next question...)

Other Job Interview Questions

• You are building a .NET assembly that will access the registry of the local machine for a factor used in a computer column. What permission set should you assign it?
• To which versions of SQL Server 2005 can you upgrade an SQL Server 2000 MSDE SP3 edition database?
• Which of the following is not available to you?
• Error severity 13 indicates what?
• If you want to apply a hot fix to SQL Server 2005, do you need to apply them all in order?
• In SQL Server 2005, which of the following schema changes are supported for the publication objects of a replicated database?
• Which of the following is not available to you?
• What value should you use for the BROKER_INSTANCE parameter?
• How secure are encrypted stored procedures, triggers and views?
• Setting the TRUSTWORTHY database property to ON allows you to execute the following from within the context of the database: Submitted by Charles Hawkins
• More...