What level of permissions does a user need to cr

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

(Continued from previous question...)

What level of permissions does a user need to create an assembly with UNSAFE permissions?

Answer
sysadmin

Explanation
Only a sysadmin can create assemblies that are specified as unsafe.

(Continued on next question...)

Other Job Interview Questions

• Which is these is not necessary for a well-formed XML document?
• How many of these servers can you consolidate?
• When you declare an XML variable in SQL Server 2005, what are the two types of typed XML data. What are they?
• 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?
• Yesterday's QOD How are comments denoted in an XML document?
• How many users can be added to an application role in SQL Server 2005?
• A certificate is like which type of key in SQL Server 2005 encryption?
• In SQL Server 2000, how can you send an alert without sending a message to the client?
• What does REVERT do in SQL Server 2005?
• you want to be sure that SQL authenticated logins must abide by the password policy.. .
• More...