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 the importance of three tier architecture?

QuestPond,

1083

What is the difference between functions and scalar functions?

EXL,

1200

How to call a function from a stored procedure in SQL Server ?

HCL,

1022

What is 'Join' and explain its various types.

Genpact,

1129

What do you do in data exploration

EXL,

983

Difference between 2NF &3NF ?

Cap Gemini,

1081

What will happen when a Rollback statement is executed inside a trigger?

Flextronics, Hexaware,

1 1967

What do you mean by a dependent functionality in a build?

HCL,

1137

How do you create type- insensitive operator?

EXL,

1035

Give me a SQL Query to find out the second largest company?

Ernst Young,

1160

Explain different types of Normalization.

HPCL, Hughes Systique Corporation, Ittiam Systems,

1 1825

What is the difference between Triggers and Stored Procedure?

HCL,

1093

Explain the concept of view and Types of views in SQL server?

HCL,

987

How to connect of datebase with sql express.?

MCN Solutions,

1094

What do you mean by a Composite primary key?

Genpact,

1095

Un-Answered Questions { SQL Server }

When we should use @@error?

959

What is difference between index and primary key?

1096

Explain how you can configure a running aggregate in SSRS?

163

Tell me the difference between clustered and non-clustered index?

931

How to delete all rows with truncate table statement in ms sql server?

997

State the difference between local and global temporary tables?

1113

How and why use sql server?

998

What are parameterized reports? What are cascading parameters in ssrs reports?

156

Explain indexes disadvantages?

1076

What is the use of attributehierarchyvisible ? : sql server analysis services, ssas

1064

Explain filtered indexes benefits?

996

What is server-level principal?

122

Why use “pivot” in sql server?

1105

What is the data type of time?

961

What is a result set object returned by mssql_query()?

1149

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