Sqlserver Interview questions

Total available count: 45
Subject - Databases
Subsubject - Sqlserver

What are the authentication modes in SQL Server?

There are two types of Authentication 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)

What are the properties and different Types of Sub-Queries?
When is the use of UPDATE_STATISTICS command?
What is difference between DELETE and TRUNCATE commands?
What are the difference between clustered and a non-clustered index?
What is the difference between a primary key and a unique key?