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 are Row versions of DataRow?

1081

What is data block and how to define data block size?

1080

What is cursors?

NA,

1260

Can you get second highest salary from the table?

QuestPond,

1009

What is the difference between a check constraint and a rule?

1349

What is a Join and explain its types?

1150

What is the user of Primary key?

1029

How does index makes search faster?

QuestPond,

1023

How can we delete Duplicate row in table?

Wipro,

1112

How would you use user_constraints table in DB?

Wipro,

1060

Why do we backup Active Directory ?

1099

What is normalization? Describe its different types.

Wipro,

1152

What is the difference between DATETIME2 and DATETIME?

Infosys,

1128

What do you mean by the term 'normalization'?

Tech Mahindra,

1282

What is the difference between clustered and a non-clustered index?

NA,

1077

Un-Answered Questions { SQL Server }

You want to use a perspective in an mdx query. How do you select the perspective?

246

What is bit data type? What's the information that can be stored inside a bit column?

968

How can delete duplicate records in cte in sql server?

1015

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

1119

What is field in algebra?

1092

Explain trigger classes i.e. Instead of and after trigger?

918

What is inner join in sql server joins?

1096

Explain the dirty pages?

1050

What is user-defined scalar function?

1009

What is a trigger and its types?

1039

How to defragment table indexes?

1038

What factors you will consider calculating the storage requirement for that view?

991

What is rolap and its advantage? : sql server analysis services, ssas

1330

How to find the login name linked to a given user name?

1059

What are the different types of replication are there in sql server 2000?

1087

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