Multiple choice technology databases

What are the modes of authentication in SQL server database.

  1. Builtin/Administrator

  2. Windows authentication

  3. Mixed mode

  4. SQL authentication
Reveal answer Fill a bubble to check yourself
B,C Correct answer
Explanation

SQL Server supports two authentication modes: Windows Authentication (uses Windows Active Directory accounts) and Mixed Mode (allows both Windows Authentication and SQL Server authentication). 'Builtin/Administrator' is not a mode name. 'SQL authentication' alone refers to the SQL Server-specific authentication used within Mixed mode, not a standalone mode.

Keep practicing — related questions