SQL Administrator Question:
Download Job Interview Questions and Answers PDF
Tell me 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 Administrator Interview Questions And Answers
PDF
| Previous Question | Next Question |
| Explain me where do you find the default Index fill factor and how to change it? | Tell me which autogrowth database setting is good? |