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 the Difference Between Primary and Foreign Key?

Accenture, Deloitte, JPMorgan Chase, Maveric,

1062

What are the differences between DDL, DML and DCL in SQL?

ABB, Aspire, Infogain,

1277

What does REVERT do in SQL Server 2005?

HCL,

1007

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?

Facebook,

1019

how would you write a sql query to compute a frequency table of a certain attribute involving two joins? What changes would you need to make if you want to order by or group by some attribute? What would you do to account for nulls?

Facebook,

1688

how would you improve etl (extract, transform, load) throughput?

LinkedIn,

1071

define and explain the differences between clustered and non-clustered indexes.

Microsoft,

1244

what are the different ways to return the rowcount of a table?

Microsoft,

1048

what is datawarehouse?

Informatica,

1147

We are updating a field in sql and alter the row also.after giving the commit command the system is crashed.what will happen to the commands given,whether it will update and alter the table or not?

Amdocs, Apps Associates,

1438

how will add additional conditions in sql?

Amdocs, Apps Associates,

1164

What are SSL and TSL protocols?

Wipro,

1029

What is the difference between Normalization and De-normalization?

TCS,

1137

What does COMMIT command do?

Amdocs,

1113

Write a program to fetch first 10 records from a file?

Amdocs,

1058

Un-Answered Questions { SQL Server }

What are differences in between sql server 2012 and sql server 2016?

1085

Does server sql treat char as a variable-length or fixed-length column?

1086

what protocol both networks use? : Sql server database administration

1013

What is cross join in sql server joins?

1195

What is a user-defined function in the sql server and what is its advantage?

1135

How can i Relate Tables in SSIS

1134

What is difference between rollback immediate and with no_wait during alter database?

1128

What are the different types of backups avaialabe in sql server 2005?

1062

What are parameterized reports?

204

What is optimistic concurrency?

1089

How to convert character strings into numeric values?

1144

What do you mean by tablesample?

1122

What are the advantages of mirroring?

1041

What are the advantages dts has over bcp?

1046

What is attribute? : sql server analysis services, ssas

1066

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