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 6368

What is BCP? When do we use it?

2 10418

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

3 9366

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

2 8311

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

3 14548

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

3 16543

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

Descon, Digital Domain,

4 31536

What is database normalization?

Deloitte, Digicel, JPMorgan Chase, Verifone,

7 18963

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

eFunds,

5 17389

What is a trigger?

7 9283

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 16151

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

1 6496

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

2 11045

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

3 13285

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

5 40643

Un-Answered Questions { SQL Server }

Do you know what is a linked server in sql server?

1073

What is the difference between primary key and unique constraints?

1015

What do you understand by a view? What does the with check option clause for a view do?

1068

How to use clusters?

1021

What’s the distinction between dropping a info and taking a info offline?

1095

What is replace and stuff function in sql server?

1121

What happens if ntwdblib.dll is missing on your machine?

1192

What is the difference between locking and multi-versioning?

1043

What changes in the front end code is needed if mirroring is implemented for the high availability? : sql server database administration

1082

What is snapshot replication?

1102

What is difference between inner join and full join?

1117

What are a database and a data warehouse?

1078

What is etl - extraction, transformation, and loading?

963

When do you think a developer should use sql server-based cursors?

1107

Ms sql server index?

1106

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