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?

1 1093

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

1 1089

What is cursors?

NA,

1 1277

Can you get second highest salary from the table?

QuestPond,

1 1020

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

1 1376

What is a Join and explain its types?

1 1165

What is the user of Primary key?

1 1036

How does index makes search faster?

QuestPond,

1 1032

How can we delete Duplicate row in table?

Wipro,

1 1122

How would you use user_constraints table in DB?

Wipro,

1 1071

Why do we backup Active Directory ?

1 1106

What is normalization? Describe its different types.

Wipro,

1 1165

What is the difference between DATETIME2 and DATETIME?

Infosys,

1 1138

What do you mean by the term 'normalization'?

Tech Mahindra,

1 1304

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

NA,

1 1085

Un-Answered Questions { SQL Server }

What is normalization and what are the advantages of it?

1042

What are the kinds of subquery?

1087

Can sql servers link to other servers like oracle?

900

How to remove duplicate rows from table except one?

1070

what is the Ticketing tool used in Wipro technologies at Bangalore...???

8210

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

Disadvantages of the indexes?

1205

What is subquery? Explain the properties of a subquery?

1046

How to connect php with different port numbers?

1159

Equi join and non equi join is possible with sql server?

1110

Can we do dml on views?

1024

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

1177

What are the source of constraints?

994

What are different types of constraints?

981

do you know how to configure db2 side of the application? : Sql server database administration

1106

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