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?

1018

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

1021

What is cursors?

NA,

1174

Can you get second highest salary from the table?

QuestPond,

959

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

1237

What is a Join and explain its types?

1097

What is the user of Primary key?

975

How does index makes search faster?

QuestPond,

969

How can we delete Duplicate row in table?

Wipro,

1056

How would you use user_constraints table in DB?

Wipro,

1003

Why do we backup Active Directory ?

1037

What is normalization? Describe its different types.

Wipro,

1102

What is the difference between DATETIME2 and DATETIME?

Infosys,

1070

What do you mean by the term 'normalization'?

Tech Mahindra,

1199

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

NA,

1018

Un-Answered Questions { SQL Server }

What is the difference between ROW_NUMBER and Ranking function in SQL SERVER?

1141

Explain Reporting Life Cycle?

127

What is report subscription?

123

How to check what was the last restore transaction LSN in Log shipping or Mirroring? when we don't have a Monitor or witness server.

3872

What is a field name?

957

What is difference between equi join and inner join?

942

What are the system database in sql server 2008?

1028

Explain rdbms?

1026

What is xml datatype?

1074

Explain the dirty pages?

998

Can a table have 2 primary keys?

980

what are the different stages of Report Processing?

135

How do I find the size of a sql server database?

922

What is an execution plan?

1138

What is auditing in sql server?

920

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