Can a particular event in SQL Server 2005, such

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

(Continued from previous question...)

Can a particular event in SQL Server 2005, such as the CREATE USER command, have more than one DDL trigger assigned to it?

Answer
Yes
Explanation
An event can have multiple triggers assigned to it.

(Continued on next question...)

Other Job Interview Questions

• 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?
• Where does Profiler store its temporary data in SQL Server 2005?
• What does this method in SQL Server 2005's SMO equate to in T-SQL? db.CheckTables(RepairType.None)
• 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 CONTINUE do in T-SQL?
• What is one of the downsides of using RAID 5 as opposed to RAID 1?
• Can you use a CASE statement in a WHERE clause?
• You are looking to secure your publisher to prevent unauthorized logins from accessing the data through replication. Where do you add the list of logins that have access?
• You have specified that a SQL Server 2005 login must respect the password policy on a Windows XP host. Which of the following are valid passwords for the user Kendall?
• You are loading 100 rows of data into a narrow table that is heavily used by your production inventory queries...
• More...