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 different types of statements that are supported by sql?

1099

Characterize join and name diverse sorts of joins?

1022

Why would you use sql agent?

1346

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

1062

What is set nocount on?

994

What are the different types of upgrades that can be performed in sql server?

1215

What does null mean?

1053

What is the difference between truncate and delete commands?

1110

What is normalization? What number of normalization shapes are there?

1159

What is collation?

1195

What are the operating modes in which database mirroring runs?

1137

Define self join?

1078

Does transparent data encryption provide encryption when transmitting data across the network?

1100

What are transactions and its controls?

1106

What is the cartesian product of table?

1064

Un-Answered Questions { SQL Server }

What is the difference in accessing db between sql server vs sql azure?

174

What is system stored procedures?

1085

Can we write trigger for view?

1071

What xml support does the sql server extend?

1059

What are “phantom rows”?

1706

How will you find out if there are expensive SQL statements running or not?

1071

what is a sub-report?

146

Difference between report and query parameter. Why do we need different type of parameter?

1011

What is the purpose of grouping data in a report?

1014

Write a code to select distinct records without using the DISTINCT keyword.

1186

How you provide security to cube? : sql server analysis services, ssas

1010

What are three ways you can use an identity value inside a trigger? Why would you prefer one way over another?

1044

How do I trace a query in sql server?

1000

John exports information periodically from a microsoft sql server database to an oracle database what is the best way to do this?

988

What will be the maximum number of index per table?

1056

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