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,

1228

What does REVERT do in SQL Server 2005?

HCL,

959

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,

1629

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,

1000

what is datawarehouse?

Informatica,

1112

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,

1101

What are SSL and TSL protocols?

Wipro,

985

What is the difference between Normalization and De-normalization?

TCS,

1091

What does COMMIT command do?

Amdocs,

1063

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

Amdocs,

1009

Un-Answered Questions { SQL Server }

How do I schedule a sql server profiler trace?

977

How many triggers are possible per table?

1098

How to configure and test odbc dsn settings?

1160

What are blobs, tables, and Queues? Is SQL is the standard way to query blobs, tables, and queues?

137

Explain what is use of dbcc commands?

1057

What is openxml in sql server?

1168

Explain sql server authentication modes?

1127

What are exact numeric data types in ms sql server?

1074

What is the security principal at the server level that represents your session?

1014

Explain what are the different index configurations a table can have?

1109

How do I view views in sql server?

1005

Which is faster statement or preparedstatement?

945

What is server-level principal?

122

How to return the top 5 rows from a select query in ms sql server?

1136

How do I manually uninstall an instance of sql server 2016?

1038

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