SQL Server Database Administrator Question:
Download Job Interview Questions and Answers PDF
What authentication modes does SQL Server support?
Answer:
SQL Server supports Windows Authentication and mixed-mode. Mixed-mode allows you to use both Windows Authentication and SQL Server Authentication to log into your SQL Server. It's important to note that if you use Windows Authentication, you will not be able to log in as sa.
Download SQL Server DB Administrator Interview Questions And Answers
PDF
| Previous Question | Next Question |
| What are the steps to take to improve performance of a poor performing query? | What is blocking and how would you troubleshoot it? |