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 25482

What are functions

3 22744

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

4 35988

What command do we use to rename a db?

IBM,

5 13700

What are the four main query statements?

Wipro,

7 21947

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

3 15966

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

2 20596

What is SQL server agent?

HCL, SAP Labs,

2 9813

What is the purpose of UPDATE STATISTICS?

2 13801

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

3 8887

Difference between Function and Stored Procedure?

C1 India, NA,

9 21802

What is data integrity? Explain constraints?

Thinksoft,

1 26018

Explain some DBCC commands?

6 19912

What are tasks?

Wipro,

3 13231

What is the purpose of using COLLATE in a query?

1 18732

Un-Answered Questions { SQL Server }

What is difference between index and primary key?

1052

How to install sql server 2005 express edition?

1064

What are acid properties of transaction?

906

What is user defined stored procedures?

883

How to drop existing indexes in ms sql server?

1021

What is SQL Azure Fabric?

108

How to list all objects in a given schema?

996

How you would rewrite the sql query to return the customerid sorted numerically?

945

What is 5nf in normalization form?

944

Explain different forms of normalization?

894

what is a self join? : Sql server database administration

971

What is the default fill factor value?

1025

What is query parameter in ssrs?

145

What is a fan-out query in SQL Azure?

121

What is an indice?

991

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