Sqlserver interview questions


Total available count: 38
Subject - Databases
Subsubject - Sqlserver

What are the authentication modes in SQL Server?

There are two types of Authentications available in SQL Server.

1. Windows mode

2. Mixed Mode (SQL and Windows)

To change authentication mode in SQL Server click Start, Programs, Microsoft SQL Server and click SQL Enterprise Manager to run SQL Enterprise Manager from the Microsoft SQL Server program group. Select the server then from the Tools menu select SQL Server Configuration Properties, and choose the Security page.




Next 5 interview question(s)

1
What are the data types in SQL Server?
2
What are the difference between clustered and a non-clustered index?
3
What are the differences between UNION and JOINS in SQL Server?
4
What are the different index configurations a table can have?
5
What are the properties and different Types of Sub-Queries?


Comments