When you install SQL Server 2005 and create a ne

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

(Continued from previous question...)

When you install SQL Server 2005 and create a new database, is a Database Master Key created?

Answer
No
Explanation
A database master key is not created when a database is created. It must be created by an administrator.

(Continued on next question...)

Other Job Interview Questions

• Which framework would you use to manage this database programatically?
• In SQL Server 2005 T-SQL, what does the CONTINUE statement do?
• Which permission in SQL Server 2005 allows you to switch your security context to that of another user with the EXECUTE AS statement?
• 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 format are images rendered in if they were stored originally in another format?
• 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?
• What does this method in SQL Server 2005's SMO equate to in T-SQL? db.CheckTables(RepairType.None)
• You want to disable the trigger dEmployee on the HumanResources...
• You are loading 100 rows of data into a narrow table that is heavily used by your production inventory queries...
• What T-SQL function can achieve this?
• More...