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 25682

What are functions

3 22883

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

4 36179

What command do we use to rename a db?

IBM,

5 13929

What are the four main query statements?

Wipro,

7 22244

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

3 16139

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

2 20729

What is SQL server agent?

HCL, SAP Labs,

2 9960

What is the purpose of UPDATE STATISTICS?

2 13908

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

3 9050

Difference between Function and Stored Procedure?

C1 India, NA,

9 22179

What is data integrity? Explain constraints?

Thinksoft,

1 26104

Explain some DBCC commands?

6 20188

What are tasks?

Wipro,

3 13375

What is the purpose of using COLLATE in a query?

1 18845

Un-Answered Questions { SQL Server }

what is the information that can be stored inside a bit column? : Sql server database administration

963

What is raid, and how it can influence database performance?

1054

Do you know sql server 2008 introduces automatic auditing?

980

What is log in sql server?

1146

What is RMS migrations?

2133

What is Dependency Injection and provide example?

1117

What are the differences between “row_number()”, “rank()” and “dense_rank()”?

1147

What is instead of trigger sql server?

999

Explain rdbms?

1036

What is the contrast between sql and pl/sql?

1142

What are the basic functions for master, msdb, model, tempdb databases?

1041

You are designing a database for your human resources department in the employee table, there is a field for social security number, which cannot contain null values if no value is given, you want a value of unknown to be inserted in this field what is the best approach?

1103

What are actions, how many types of actions are there, explain with example? : sql server analysis services, ssas

1026

Is resultset an interface?

967

State the difference between local and global temporary tables?

1119

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