SQL Server Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

SSRS SQL Server Reporting Services (140)
Microsoft Azure SQL (73)

SQL Server Interview Questions

Questions Answers Views Company eMail

what is web server?

Satyam,

3 25440

What are functions

3 22716

how to get the automatic backup of the database in the sql server

4 35946

What command do we use to rename a db?

IBM,

5 13660

What are the four main query statements?

Wipro,

7 21894

Which command using Query Analyzer will give you the version of SQL server and operating system?

3 15928

What is the STUFF function and how does it differ from the REPLACE function?

2 20572

What is SQL server agent?

HCL, SAP Labs,

2 9787

What is the purpose of UPDATE STATISTICS?

2 13777

What is de-normalization and when do you do it?

3 8862

Difference between Function and Stored Procedure?

C1 India, NA,

9 21738

What is data integrity? Explain constraints?

Thinksoft,

1 25993

Explain some DBCC commands?

6 19858

What are tasks?

Wipro,

3 13187

What is the purpose of using COLLATE in a query?

1 18713

Un-Answered Questions { SQL Server }

What are the types of sql server?

987

What is fill factor and pad index?

952

When does a workload on SQL Azure get throttled?

129

What is view in sql?

852

What is wide table?

885

What is the recovery model?

930

What is data source document?

978

What is partition, how will you implement it? : sql server analysis services, ssas

991

How many types of triggers are there?

1001

Can we insert data if clustered index is disabled?

889

How do triggers work?

878

What is the use of @@spid?

957

What is SQL Azure Fabric?

108

What is the difference between mysql and sql server?

940

What is the difference between clustered and non-clustered indexes in ms sql server?

936

For More Un-Answered { SQL Server } Questions Click Here