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

Let us say master db itself has no backup. Now you have to rebuild the db so what kind of action do you take?

1 6260

What is BCP? When do we use it?

2 10273

What should we do to copy the tables, schema and views from one SQL Server to another?

3 9235

What are the different types of joins and what does each do?

2 8200

What is a sub-query? When would you use one?

3 14399

What are three SQL keywords used to change or set someone?s permissions?

3 16411

What is referential integrity? What are the advantages of it?

Descon, Digital Domain,

4 31358

What is database normalization?

Deloitte, Digicel, JPMorgan Chase, Verifone,

7 18676

Using query analyzer, name 3 ways you can get an accurate count of the number of records in a table?

eFunds,

5 17209

What is a trigger?

7 9087

What is one of the first things you would do to increase performance of a query? For example, a boss tells you that ?a query that ran yesterday took 30 seconds, but today it takes 6 minutes?

Accenture, Merrill Lynch, Wipro,

2 16013

What is an execution plan? When would you use it? How would you view the execution plan?

1 6417

What does it mean to have quoted_identifier on? What are the implications of having it off?

2 10930

What are the different types of replication? How are they used?

3 13143

What is the difference between a local and a global variable?

5 40457

Un-Answered Questions { SQL Server }

What is nonclustered index with included columns ?

967

How to delete duplicate rows from table except one?

989

What is tabulation?

951

Differentiate between mongodb vs. Sql server?

1096

What is the difference between join and inner join?

1013

What is query optimization process?

1011

How extra digits are handled with numeric data type literals?

966

What do you mean by sql server agent?

990

Tell me the use of keyword with encryption. Create a store procedure with encryption?

1008

What stored procedure can you use to display the current processes?

893

What are the steps you will take to improve the performance of a poor performing query?

979

What is analysis service repository?

1023

What is normalization? Describe its different types.

1103

What is indexing in sql server with example?

1002

How do I determine how many instances of sql server are installed on a computer?

1006

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