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 22241

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

3 16137

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 9959

What is the purpose of UPDATE STATISTICS?

2 13907

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

3 9050

Difference between Function and Stored Procedure?

C1 India, NA,

9 22175

What is data integrity? Explain constraints?

Thinksoft,

1 26104

Explain some DBCC commands?

6 20187

What are tasks?

Wipro,

3 13375

What is the purpose of using COLLATE in a query?

1 18845

Un-Answered Questions { SQL Server }

Which feature in sql server 2008 has surprised you? You can name just one. : sql server database administration

934

what are defaults? : Sql server database administration

1090

What is the name of reporting services config file and what’s it’s used for?

146

What the different components of Replication and what is their use?

1068

How to create new databases with "create database" statements?

1019

what is a transaction? : Sql server database administration

992

What are the difference between primary key and unique key? : sql server database administration

941

How to create user messages with print statements in ms sql server?

987

How to test a dml trigger in ms sql server?

1042

what is normalization? : Sql server database administration

1095

what number files will a information contain in SQL Server? How many forms of information files exist in SQL Server? How many of those files can exist for a single database?

1055

How do I find the transaction log size in sql server?

961

How would you go about developing a ssrs report?

167

how to restart sql server in single user mode? How to start sql server in minimal configuration mode? : Sql server database administration

907

How do I connect to sql server database?

1010

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