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 6257

What is BCP? When do we use it?

2 10271

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 14396

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 18673

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

eFunds,

5 17208

What is a trigger?

7 9084

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 6416

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

2 10928

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

3 13140

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

5 40455

Un-Answered Questions { SQL Server }

What is the difference between ‘having’ clause and a ‘where’ clause?

1039

What is transactional replication?

967

How check triggers in sql server?

991

What is the preferred way to create a clustered and non-clustered index? Which index should you create first the clustered or non-clustered?

914

How many clustered indexes can be created on a table? I create a separate index on each column of a table. what are the advantages and disadvantages of this approach?

1111

What is meant by referential integrity?

1010

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

978

Explain how many types of relationship?

1027

What are the different ways you can create databases in sql server?

1103

Can sql server 2016 run on windows 7?

916

Explain Geometry datatype in sql server 2008 with example

989

How to get the definition of a view out of the sql server?

987

How do we upgrade from SQL Server 6.5 to 7.0 and 7.0 to 2000?

1991

Where is localdb stored?

942

Explain full-text indexing?

980

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