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 25473

What are functions

3 22739

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

4 35986

What command do we use to rename a db?

IBM,

5 13694

What are the four main query statements?

Wipro,

7 21941

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

3 15959

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

2 20594

What is SQL server agent?

HCL, SAP Labs,

2 9810

What is the purpose of UPDATE STATISTICS?

2 13799

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

3 8883

Difference between Function and Stored Procedure?

C1 India, NA,

9 21789

What is data integrity? Explain constraints?

Thinksoft,

1 26012

Explain some DBCC commands?

6 19907

What are tasks?

Wipro,

3 13228

What is the purpose of using COLLATE in a query?

1 18732

Un-Answered Questions { SQL Server }

What is 1nf 2nf?

971

Can a database be shrunk with users active?

1070

Can You Use A Stored Procedure To Provide Data To An Ssrs Report?

141

What is a database in ms sql server?

1000

What are the types of joins in sql?

1065

Do you know the different ddl commands in sql?

1006

What is transactional replication?

915

Explain what is meant by replication of database?

967

what are different types of backups available in sql server? : Sql server database administration

895

Define left outer join?

934

What is faster join or union?

1121

explain what are the steps you will take, if you are tasked with securing an sql server? : Sql server database administration

1048

How to connect a database with sql express.?

1020

Explain isolation levels that sql server supports?

993

what are the core components of SSRS?

123

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