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,

1139

Where do we generally create INDEX?

Ernst Young, Thomson Reuters,

1 3231

What do you mean by 'normalization'?

Ernst Young, Thomson Reuters,

1122

Define Unique Key?

HCL,

1066

Difference between aggregate functions of sql?

EXL,

1147

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

Ernst Young,

1338

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

MindCracker,

1080

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

HCL,

1108

Define Joins?

HCL,

1074

Suggest a method of joining two tables.

Ernst Young, Thomson Reuters,

1231

Give me any three differences between Truncate and Delete.

Genpact,

1156

What are the types of lock supported by ?

HCL,

1091

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

HCL,

1066

What is the difference between Stored Procedures and triggers?

HCL,

1133

How to update muliple row in single query?

MCN Solutions,

1113

Un-Answered Questions { SQL Server }

Explain about merge replications?

1078

What is standby servers? Explain types of standby servers.

1053

Explain the benefits of user-defined functions?

1122

What is logon trigger?

1157

What is cte (common table expression)?

1085

How to copy the tables, schema and views from one sql server to another?

1102

How to create indexed view?

1104

Distinguish between nested subquery and correlated subquery?

1113

Explain the use of keyword with encryption. Create a store procedure with encryption?

1007

What is sql injection? How to protect against sql injection attack?

1038

Please explain that what are the basic functions for master, msdb, model, tempdb and resource databases? : SQL Server Architecture

1021

What is the use of @@spid?

1048

What are the tools available in market as an alternative to sql server reporting services?

138

What is resource db in sql server?

1056

How to delete an existing database user?

1079

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