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,

1 1153

Where do we generally create INDEX?

Ernst Young, Thomson Reuters,

1 3249

What do you mean by 'normalization'?

Ernst Young, Thomson Reuters,

1 1131

Define Unique Key?

HCL,

1 1079

Difference between aggregate functions of sql?

EXL,

1 1153

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

Ernst Young,

1 1346

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

MindCracker,

1 1089

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

HCL,

1 1126

Define Joins?

HCL,

1 1086

Suggest a method of joining two tables.

Ernst Young, Thomson Reuters,

1 1243

Give me any three differences between Truncate and Delete.

Genpact,

1 1177

What are the types of lock supported by ?

HCL,

1 1099

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

HCL,

1 1079

What is the difference between Stored Procedures and triggers?

HCL,

1 1142

How to update muliple row in single query?

MCN Solutions,

1 1126

Un-Answered Questions { SQL Server }

Can we do dml on views?

1024

Explain “row_number()” in sql server with an example?

1061

What are the different subsets of sql?

1634

How to convert character strings into numeric values?

1167

How can you append an identity column to a temporary table?

1050

How do I find the sql server version?

1096

explain different types of backups avaialabe in sql server? Given a particular scenario, how would you go about choosing a backup plan? : Sql server database administration

1118

What are the kinds of subquery?

1087

What are the source of constraints?

994

what is spatial nonclustered index

1047

Is it possible to have clustered index on separate drive from original table location?

1026

What is acid mean in sql server?

1218

Where can you add custom error messages to sql server?

1190

Why we use the openxml clause?

1059

How efficient you are in oracle and SQL server?

1234

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