What is the purpose of supporting mixed mode aut

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

(Continued from previous question...)

What is the purpose of supporting mixed mode authentication (Windows Authentication and SQL Server Authentication)?

With mixed mode authentication, non-Windows clients can gain access to the MS SQL Server.

Other Job Interview Questions

• What is the main purpose of assigning a user with the "processadmin" role?
• What is default sorting order when you use "ORDER BY" clause in a query statement?
• What is a Rule is MS SQL Server?
• What is the meaning of the following T-SQL command: EXEC sp_dboption 'OrderDB', 'single user', 'true'
• Is it true that MS SQL Server is sharing work load between the server and client computers?
• What is the meaning of Data Normalization?
• What is the purpose of IAM (Index Allocation Map) in MS SQL Server?
• What is "osql"? What can you do with "osql"?
• What is a Rule is MS SQL Server?
• Does MS SQL Server support IPX/SPX?
• More...