The TRUSTWORTHY database property is by default?

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

(Continued from previous question...)

The TRUSTWORTHY database property is by default?

Answer
Off

Explanation
The correct answer is off – The TRUSTWORTHY database property indicates whether the installed instance of SQL Server trusts the database such that it can reach out and perform actions outside the database. By default it is OFF such that the database to reduce certain threats that can result from attaching a database that contains potentially harmful code.

(Continued on next question...)

Other Job Interview Questions

• You cannot execute procedures on the 2005 server. Why not?
• You cannot execute procedures on the 2005 server. Why not?
• You wish to configure event logging for your SQL Server 2005 Notification Services instance. Where would you make this change?
• In the SQL Server 2005 thesaurus XML configuration file, what is the expansion set?
• What does a report model provide in SQL Server 2005 Reporting Services?
• Which of the following is not an allocation unit in SQL Server 2005?
• If you have a replication scenario with one publisher, one distributor and one subscriber and the transaction isolation level is not set to serializable, what happens when a transaction fails on the publisher?
• Using Report Builder that is bundled with Reporting Services 2005, which of the following would work as a way to add a derived field to a report?
• What is the maximum number of instances of Analysis Services 2005 can be installed on a server?
• You want to be sure your database server if properly secured. You have two instances, a default instance and a named instance installed. Which ports do you need to open?
• More...