Which of the following modules within SQL Server

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

(Continued from previous question...)

Which of the following modules within SQL Server 2005 cannot be signed with a digital signature?

Answer
DDL triggers
Explanation
DDL triggers cannot be signed, but all the other objects can.

(Continued on next question...)

Other Job Interview Questions

• How many connections are available in SQL Server MSDE 2000?
• Which collation is used for Service Broker messages sent between the instances?
• What T-SQL function can achieve this?
• How can you you be sure that a SOAP queries that are looking for a WSDL response will be provided?
• Which of the following CREATE ASSEMBLY statement WITH PERMISSION_SET clauses sets ...
• In Full-Text Search, what is word breaking?
• Does a root element in an XML document necessarily contain all the content for a well-formed document?
• What does the CREATE SERVICE statement do in SQL Server 2005?
• You need to remove a large table from your database ...
• When a user on a remote SQL Server wants to execute a stored procedure through a linked server on your local server, what security context is used?
• More...