In SQL Server 2005, which of the following schem

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

(Continued from previous question...)

In SQL Server 2005, which of the following schema changes are supported for the publication objects of a replicated database?

Answer
All of the above.
Explanation
SQL Server 2005 replicated databases support the following schema changes for objects:
* ALTER TABLE
* ALTER VIEW
* ALTER PROCEDURE
* ALTER FUNCTION
* ALTER TRIGGER (DML only)

(Continued on next question...)

Other Job Interview Questions

• What does a return value of -1 mean from the function XACT_STATE() in SQL Server 2005?
• Which of the following is not an allocation unit in SQL Server 2005?
• If you run this, what does it return? select applock_mode('public', 'SalesApp', 'Transaction')
• 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?
• What should you have applied a patch for by now on your Windows 2003 and XP systems?
• What will occur with the following code in SQL Server 2005 if executed by Alice?
• What does this return on SQL Server 2005? select NEWSEQUENTIALID()
• For regulatory reasons, you must maintain an exact text copy of your XML documents in your SQL Server 2005 database. What datatype of storage should you choose?
• What does the sqlwb utility do?
• When creating a full-text index on a BLOB column ...
• More...