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 25490

What are functions

3 22745

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

4 35990

What command do we use to rename a db?

IBM,

5 13702

What are the four main query statements?

Wipro,

7 21950

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

3 15971

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

2 20598

What is SQL server agent?

HCL, SAP Labs,

2 9813

What is the purpose of UPDATE STATISTICS?

2 13813

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

3 8887

Difference between Function and Stored Procedure?

C1 India, NA,

9 21811

What is data integrity? Explain constraints?

Thinksoft,

1 26018

Explain some DBCC commands?

6 19917

What are tasks?

Wipro,

3 13235

What is the purpose of using COLLATE in a query?

1 18732

Un-Answered Questions { SQL Server }

What are various aggregate functions that are available?

924

Explain comment on transactions?

943

Can you explain what is sql server english query?

955

What is the difference in accessing db between sql server vs sql azure?

174

What are the kinds of subquery?

963

How many types of attribute relationships are there? : sql server analysis services, ssas

1011

How to use order by with union operators in ms sql server?

980

How will you make an attribute not process? : sql server analysis services, ssas

1021

How to implement one-to-one, one-to-many and many-to-many relationships while designing tables?

997

in a table is b in column k (manikanta,sivananda,muralidhar) i want result like (mnikanta,sivnanda,murlidhar) please slove it

1464

What are partitioned views?

946

What is coalesce in sql server?

999

How to copy data from one table to another table?

942

What is de-normalization and what are some of the examples of it?

935

Find columns used in stored procedure?

942

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