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 6152

What is BCP? When do we use it?

2 10146

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

3 9108

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

2 8098

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

3 14253

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

3 16288

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

Descon, Digital Domain,

4 31191

What is database normalization?

Deloitte, Digicel, JPMorgan Chase, Verifone,

7 18398

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

eFunds,

5 17002

What is a trigger?

7 8852

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 15891

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

1 6353

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

2 10833

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

3 12991

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

5 40222

Un-Answered Questions { SQL Server }

what is a correlated sub-query? : Sql server database administration

904

how you can list all the tables in a database?

978

What is transaction server distributed transaction?

988

How do you start single user mode in clustered installations?

908

Create a dts package to produce a text file using the ‘update statistics’ command for the tables in a database with obsolete statistics.

983

Stored Procedure returns data from multiple tables. How to access it in your ASP.Net code?

1016

What is the difference between DataRow.Delete() and DataRow.Remove()?

1173

What according to you is the difference between mysql and sql server performance?

1029

What is a fan-out query in SQL Azure?

121

What is dimension table? : sql server analysis services, ssas

981

what are the steps you will take, if you are tasked with securing an sql server? : Sql server database administration

970

What is abstracting periodical?

903

What is data modeling and Reterminal integrity?

1915

What is use of attribute hierarchy optimized state? : sql server analysis services, ssas

1018

What does the update command do?

1062

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