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 6243

What is BCP? When do we use it?

2 10257

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

3 9215

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

2 8188

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

3 14369

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

3 16394

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

Descon, Digital Domain,

4 31330

What is database normalization?

Deloitte, Digicel, JPMorgan Chase, Verifone,

7 18630

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

eFunds,

5 17177

What is a trigger?

7 9044

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 15998

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

1 6410

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

2 10913

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

3 13125

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

5 40410

Un-Answered Questions { SQL Server }

Explain subquery and state its properties?

1034

what's the information that can be stored inside a bit column? : Sql server database administration

1020

After creating the cube, if we added a new column to the oltp table then how you add this new attribute to the cube? : sql server analysis services, ssas

945

What is unique key constraint?

1045

What is the purpose of floor function?

1028

What is the difference between migration and upgradation in sql server?

1090

hi i am working as a testengineer , so i want to no the backend data base connection can any one tell mwe in detail

2211

You accidentally delete the msdb database what effect does this have on your existing sql databases, and how do you recover?

983

What is store procedure? How do they work? When do you use?

936

What is primary key and example?

936

How to execute a stored procedure in ms sql server?

1156

explain different types of constraints? : Sql server database administration

949

How to Check if table exists in sql server?

1120

How to include date and time values in sql statements?

1079

Explain Geography datatype in SQL Server

1118

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