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,

1002

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

ABB, Aspire, Infogain,

1224

What does REVERT do in SQL Server 2005?

HCL,

951

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,

963

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,

1627

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

LinkedIn,

1023

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

Microsoft,

1192

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

Microsoft,

993

what is datawarehouse?

Informatica,

1102

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,

1381

how will add additional conditions in sql?

Amdocs, Apps Associates,

1093

What are SSL and TSL protocols?

Wipro,

977

What is the difference between Normalization and De-normalization?

TCS,

1083

What does COMMIT command do?

Amdocs,

1053

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

Amdocs,

1000

Un-Answered Questions { SQL Server }

Explain different types of Normalization.

1825

How can you fetch alternate records from a table?

956

What do you mean by SQL injection attack?

1052

What is bcp? When does it use?

939

Is null in sql server?

980

What are the different types of data sources in ssrs?

196

What is data source in connection string?

904

What is the recovery model?

980

What is open database communication (odbc)?

1056

Explain error and transaction handling in sql server?

1005

How do you improve the performance of a SQL Azure Database?

137

What are the lambda triggers?

896

How to make conditional sum in ssrs?

177

Explain triggers in sql?

942

What happens if an integer is too big for int date type?

968

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