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 25636

What are functions

3 22857

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

4 36145

What command do we use to rename a db?

IBM,

5 13880

What are the four main query statements?

Wipro,

7 22189

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

3 16108

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

2 20697

What is SQL server agent?

HCL, SAP Labs,

2 9931

What is the purpose of UPDATE STATISTICS?

2 13888

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

3 9020

Difference between Function and Stored Procedure?

C1 India, NA,

9 22106

What is data integrity? Explain constraints?

Thinksoft,

1 26090

Explain some DBCC commands?

6 20133

What are tasks?

Wipro,

3 13359

What is the purpose of using COLLATE in a query?

1 18823

Un-Answered Questions { SQL Server }

What are the different types of locks in the database?

917

What is difference between after and before?

1070

What is named calculation? : sql server analysis services, ssas

967

How we can refresh the view?

1102

Does partitioning improve performance sql server?

970

How to view existing indexes on an given table using sp_help?

1121

Â Explain what is sql override for a source taLle in a mapping?

995

Why olap is used?

961

What is difference between joins and subqueries?

1108

Explain Normalization and DE normalization

1099

How to query multiple tables jointly?

977

What is sub-query in sql server? Explain its properties.

1081

When would you use an insert into .. Select option versus an insert into .. Values option? Give an example of each?

1093

what is a join? : Sql server database administration

1225

How do you start single user mode in clustered installations?

934

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