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,

1124

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

Genpact,

1255

Explain Geometry datatype in sql server 2008 with example

Infosys,

974

What is the Control Flow in SSIS

HCL,

1085

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

MCN Solutions,

1053

What are the different types of cursor?

HCL,

1090

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

Genpact,

2 3131

What is BLOCK statements in SQL?

HCL,

1261

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

HCL,

1092

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

HCL,

1053

What the difference between UNION and UNIONALL?

HCL,

1038

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

Essar,

1011

Why I have to use stored procedures?

Cognizant,

1031

What is PROJECTION Operation?

Infosys,

1011

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

HCL,

1258

Un-Answered Questions { SQL Server }

what is raid? : Sql server database administration

1035

What is the impact on other user sessions when creating indexes?

918

What is the difference between a primary key and a unique key? Are they the same?

1075

Which event (check constraints, foreign key, rule, trigger, primary key check) will be performed last for an integrity check?

1000

Define ACID properties in a Database?

1051

What do you mean by sql server 2005 express management tools?

1295

What are the steps to follow to configure SQL*Net?

1029

what are different types of raid configurations? : Sql server database administration

1051

Write a SQL queries on Self Join and Inner Join.

1038

What happens to a statement batch if there is a compilation error?

962

Can we call stored procedure in view in sql server?

894

What are the advantages of using stored procedures?

944

What is sql or structured query language?

1143

What is database mirroring?

1106

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

1065

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