When you use the sp_xml_preparedocument stored p

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

(Continued from previous question...)

When you use the sp_xml_preparedocument stored procedure in SQL Server 2000, what is returned?

Answer: An integer acting as a handle to the document.
Explanation: The handle, or pointer to the XML document is returned. This is an integer value that you can use to refer to the document in other stored procedures.

(Continued on next question...)

Other Job Interview Questions

• 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?
• What does this method in SQL Server 2005's SMO equate to in T-SQL? db.CheckTables(RepairType.None)
• What does a return value of -1 mean from the function XACT_STATE() in SQL Server 2005?
• Does a root element in an XML document necessarily contain all the content for a well-formed document?
• Where can you view the list of server-scoped DDL triggers?
• You are implementing replication across the Internet for a large bank that wishes to move up to date pricing information...
• What does REVERT do in SQL Server 2005?
• A .NET assembly running with UNSAFE permissions can do which of the following?
• Clicking File, Save in Report Builder does which of the following?
• What does a report model provide in SQL Server 2005 Reporting Services?
• More...