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

Are all views updatable ?

MCN Solutions,

1 1210

How each E-R model constructs can be mapped to the relational model?

HCL,

1 1058

Tell me about normalization in DBMS.

Honeywell, Zomato,

1 1070

what is the difference between count(*) and count(1) ?

MCN Solutions,

1 1140

Relational calculus is what type of language?

HCL,

1 1111

How can i Relate Tables in SSIS

HCL,

1 1146

What are audit control procedures?

Ernst Young, Thomson Reuters,

1 1045

Suppose we have a table "MyTable" containing 10 rows, what query should be executed to update the odd rows "Salary" as 9000?

MCN Solutions,

1 1043

What is the Disadvantage of indexed sequential file.

HCL,

1 1144

Explain Geography datatype in SQL Server

Infosys,

1 1203

What is the difference between implicit and explicit transaction?

1 1058

Tell me about joins in database system and explain each in detail.

Axtria, ITC Indian Tobacco Company,

1 1116

What is SubQuery in SQL Server 2008

HCL,

1 1083

How to find Duplicate Records In table?

HCL,

1 1087

What is the beast way to write CTE in SQL Server ?

HCL,

1 1108

Un-Answered Questions { SQL Server }

If you're given a raw data table, how would perform etl (extract, transform, load) with sql to obtain the data in a desired format?

1034

What is temporary table in sql server? Why we use temp table?

1001

What are the risks of storing a hibernate-managed object in a cache? How do you overcome the problems?

1177

List the ways in which dynamic sql can be executed?

1071

Disadvantages of the indexes?

1207

Why should you use or avoid select * statements?

1094

what is the difference between openrowset and openquery?

1174

What is standby servers? Explain types of standby servers.

1067

What are the different subsets of sql?

1635

How raid can influence database performance?

1093

Is there any performance difference between if exists (select null from table) and if exists (select 1 from table)?

1015

If any stored procedure is encrypted, then can we see its definition in activity monitor?

1055

What are the kinds of subquery?

1087

What are the different types of subquery?

1222

How to convert numeric expression data types using the cast() function?

1135

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