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 are the features of Embedded SQL

HCL,

1173

What are cursors? Explain the different types of cursors Enlist a few disadvantages of cursors.

Genpact,

1329

Explain Geometry datatype in sql server 2008 with example

Infosys,

1049

What is the Control Flow in SSIS

HCL,

1146

Difference Between ORDER BY Clause and GROUP BY Clause in SQL?

MCN Solutions,

1103

What are the different types of cursor?

HCL,

1149

How would you retrieve Unique rows from table without using UNIQUE and DISTINCT keyword?

Genpact,

2 3231

What is BLOCK statements in SQL?

HCL,

1310

Explain the difference between delete,drop and truncate in SQL Server?

HCL,

1159

Stored Procedure returns data from multiple tables. How to access it in your ASP.Net code?

HCL,

1113

What the difference between UNION and UNIONALL?

HCL,

1086

What is BCNF? How is it better than 2NF & 3NF?

Essar,

1065

Why I have to use stored procedures?

Cognizant,

1095

What is PROJECTION Operation?

Infosys,

1075

Where are SQL server users names and passwords are stored in sql server?

HCL,

1326

Un-Answered Questions { SQL Server }

What are the main differences between #temp tables and @table variables and which one is preferred?

1134

How to create an identity column?

1301

Explain triggers in sql?

1003

How to handle error or exception in sql?

1036

What is sql server database?

1079

What are truncate options available in sql server? : sql server database administration

1083

what is a major difference between sql server 6.5 and 7.0 platform wise? : Sql server database administration

946

Can you name some of the dml commands in sql?

1076

How raid can influence database performance?

1084

How to create percentile function?

159

What does normalization do to data?

1140

How do you manipulate data?

949

How to modify the underlying query of an existing view?

1027

Explain indexed views?

1027

How to trouble shoot if unable to connect SQL Server

2031

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