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 function of ROLLUP ?

HCL,

1079

Where do we generally create INDEX?

Ernst Young, Thomson Reuters,

1 3137

What do you mean by 'normalization'?

Ernst Young, Thomson Reuters,

1056

Define Unique Key?

HCL,

995

Difference between aggregate functions of sql?

EXL,

1100

Do you think BCNF is better than 2NF & 3NF? Why?

Ernst Young,

1276

Write a query for primary key constraint with identity key word?

MindCracker,

1026

Can we return Data from 4(more than 1) tables in stored procedure?

HCL,

1055

Define Joins?

HCL,

1023

Suggest a method of joining two tables.

Ernst Young, Thomson Reuters,

1151

Give me any three differences between Truncate and Delete.

Genpact,

1100

What are the types of lock supported by ?

HCL,

1042

What is the name of the system variable that returns the number of rows affected by a SQL statement?

HCL,

1005

What is the difference between Stored Procedures and triggers?

HCL,

1075

How to update muliple row in single query?

MCN Solutions,

1052

Un-Answered Questions { SQL Server }

Why do we need different type of parameter?

1051

What is log ldf?

976

Does a server store data?

920

Explain the different types of joins?

989

How to make remote connection in database?

1002

What is executereader?

948

What is 2nf example?

988

what kind of lan types do you know? : Sql server database administration

974

How adventureworkslt tables are related?

925

What happens if we shrink log file in sql server?

979

What is normalization of database?

1097

What is an execution plan? When would you use it?

972

What is key attribute?

929

What does Master database contains?

1130

What is equi join with example?

1116

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