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 25643

What are functions

3 22858

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

4 36147

What command do we use to rename a db?

IBM,

5 13888

What are the four main query statements?

Wipro,

7 22193

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

3 16112

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

2 20702

What is SQL server agent?

HCL, SAP Labs,

2 9935

What is the purpose of UPDATE STATISTICS?

2 13891

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

3 9026

Difference between Function and Stored Procedure?

C1 India, NA,

9 22117

What is data integrity? Explain constraints?

Thinksoft,

1 26090

Explain some DBCC commands?

6 20140

What are tasks?

Wipro,

3 13363

What is the purpose of using COLLATE in a query?

1 18828

Un-Answered Questions { SQL Server }

How to generate create table script on an existing table in ms sql server?

1138

what are the new features in SSRS?

134

how can you attach more than 20 ldf files in sql server

1991

What is the difference between ddl and dml?

1042

What is change data capture (cdc) feature?

1050

How do I view views in sql server?

996

What is conditional split?

1055

Explain the truncate command? : SQL Server Architecture

1160

What is unique key constraint?

1044

Can you explain different types of locks in sql server?

939

What is transaction server auto commit?

1056

Which database stores information about replication?

1056

What is the process of indexing?

1003

how would you store your query in an SSRS report or a Database server?

162

What specific conditions database should meet, before you can bulk copy data into it using bcp?

975

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