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

What is SCOPE_IDENTITY() in sql

Cap Gemini,

4 12347

What is difference between restoration and recovery in SQLServer?

Microsoft,

3 11955

Why we need to use secondry database file? though, we can do same work using primary database file also.

Microsoft,

2 7008

What is difference between process and thread? Explain lazy writer funcationality.

Microsoft,

2 8271

What is live lock and deadlock? what is Lock escalation?

Microsoft,

2 9413

What is the best way to move n number of DTS package from one SQLServer to another SQLServer?

RBS,

1 4477

What is Primary key and foreign key? Give an example

TCS,

4 9913

How to connect PK and FK?

2 6148

What is the SQL?????????????????????????????

CMS,

5 8504

Hi all, can any one please tell me the difference between sql server 2008 and orace 9i

HP,

2008

what is an sql server?

1 4336

find 2nd highest salary of person using cursor concept?

HCL,

6 12098

how to find the second salary?

HCL, Prithvi,

10 13334

How to swap the data of two columns in a table. both the columns containing varchar values.

9 17812

What are the steps need to be take improve the speed of a SQLDATA Server?

IBM,

2 5325

Un-Answered Questions { SQL Server }

What is forward - only cursors / read only cursor?

1134

Define magic tables in sql server?

1117

Give me any three differences between Truncate and Delete.

1156

What is tabulation?

1012

What is bookmark link in ssrs?

251

Define cursor locking

1060

What are scalar functions in sql?

1208

how you can list all the tables in a database?

1067

What is the benefit of normalization?

1135

What is a database in ms sql server?

1105

What is difference between temp table and cte?

1072

What is ssl in sql server?

1132

Explain view in sql server?

1091

Explain the microsoft sql server delete command? : SQL Server Architecture

1147

What is transaction server explicit transaction?

1088

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