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,

1006

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

ABB, Aspire, Infogain,

1229

What does REVERT do in SQL Server 2005?

HCL,

961

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,

967

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,

1631

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

LinkedIn,

1026

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

Microsoft,

1194

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

Microsoft,

1001

what is datawarehouse?

Informatica,

1114

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,

1385

how will add additional conditions in sql?

Amdocs, Apps Associates,

1103

What are SSL and TSL protocols?

Wipro,

985

What is the difference between Normalization and De-normalization?

TCS,

1092

What does COMMIT command do?

Amdocs,

1065

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

Amdocs,

1011

Un-Answered Questions { SQL Server }

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

1046

Can sql servers linked to other servers?

1043

what is the difference between Tabular and Matrix report?

170

What are data resources?

911

What is the fastest way to permanently delete a 1 million row table named customers?

1255

What are cursors? Explain the different types of cursors Enlist a few disadvantages of cursors.

1268

What are the different sql server versions?

980

Describe in brief system database.

1011

What is difference between count (*) and count 1?

929

What are the steps you can take to avoid “deadlocks”?

978

Explain how you can configure a running aggregate in SSRS?

163

Does windows server 2016 come with sql server?

934

What is RAID? What are the different types of RAID configurations?

1136

Do you think BCNF is better than 2NF & 3NF? Why?

1278

What is awe?

1012

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