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 25687

What are functions

3 22889

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

4 36189

What command do we use to rename a db?

IBM,

5 13935

What are the four main query statements?

Wipro,

7 22253

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

3 16153

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

2 20734

What is SQL server agent?

HCL, SAP Labs,

2 9971

What is the purpose of UPDATE STATISTICS?

2 13912

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

3 9057

Difference between Function and Stored Procedure?

C1 India, NA,

9 22187

What is data integrity? Explain constraints?

Thinksoft,

1 26107

Explain some DBCC commands?

6 20196

What are tasks?

Wipro,

3 13381

What is the purpose of using COLLATE in a query?

1 18847

Un-Answered Questions { SQL Server }

How to apply filtering criteria at group level with the having clause in ms sql server?

1002

What is the difference between char, varchar and nvarchar?

1024

What is the use of attributehierarchyvisible ? : sql server analysis services, ssas

1066

Can we shrink data file in sql server?

1051

How to list all login names on the ms sql server?

1143

Why use stored procedures in sql server?

1016

What is buffer cash in sql server?

1154

What are SSL and TSL protocols?

989

List the advantages of using stored procedures?

1056

Difference between Inner vs outer joins?

952

Explain unique key in sql server?

1013

What options are available to audit login activity? : sql server security

1153

What is correlated subquery in sql server?

1072

What are the properties of primary key?

974

List out what other servers you can use with ssrs?

139

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