You have specified that a SQL Server 2005 login

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

(Continued from previous question...)

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?

All of the above are valid

Explanation
On a Windows XP host, the password policy is not enforced because the appropriate API call is not available on the operating system.

(Continued on next question...)

Other Job Interview Questions

• You are looking to import a large amount of data from a remote OLEDB data source that is not a text file. Which of the following techniques can you use?
• What is the quickest way to get them working?
• You are building a .NET assembly that will access the registry of the local machine for a factor used in a computer column. What permission set should you assign it?
• In the REPEATABLE READ isolation level, what phenomena is still possible?
• Which of the following classes provide the context of the caller to SQLCLR Assemblies? Submitted by Michael Coles
• You have upgraded your SQL Server 2000 on Windows 2000 server to SQL Server 2005 to take advantage ...
• Which query will return a list of the synonyms in your database?
• Which of the following services is instance-aware?
• How is Thesaurus data configured in SQL Server 2005 Full-Text Search?
• Which of the queries is the best one for Janice to use to return the information she has been requested to provide?
• More...