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 25795

What are functions

3 23008

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

4 36329

What command do we use to rename a db?

IBM,

5 14095

What are the four main query statements?

Wipro,

7 22435

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

3 16265

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

2 20832

What is SQL server agent?

HCL, SAP Labs,

2 10094

What is the purpose of UPDATE STATISTICS?

2 13995

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

3 9180

Difference between Function and Stored Procedure?

C1 India, NA,

9 22477

What is data integrity? Explain constraints?

Thinksoft,

1 26201

Explain some DBCC commands?

6 20384

What are tasks?

Wipro,

3 13499

What is the purpose of using COLLATE in a query?

1 18918

Un-Answered Questions { SQL Server }

What is ms sql server triggers?

1064

What is mean by dml?

1057

How to find which stored procedure is currently running in sql server?

1038

Can we write a distributed query and get some data which is located on other server and oracle database?

1275

Describe and explain about SQL native client?

1150

What happens when the SQL Azure database reaches Max Size?

113

If user is owning any SQL Objects, can we drop that user

2127

How to list all triggers in the database with sys.triggers in ms sql server?

1122

How can I know what locks are running on which resource?

992

Why olap is used?

1026

How do I setup a sql server database?

1124

What is sleeping status in sql server?

1071

How can you append an identity column to a temporary table?

1028

What are the extra roles available in msdb? : sql server security

1178

What is a select query statement in ms sql server?

1124

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