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 12356

What is difference between restoration and recovery in SQLServer?

Microsoft,

3 11964

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

Microsoft,

2 7011

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

Microsoft,

2 8277

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

Microsoft,

2 9425

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

RBS,

1 4483

What is Primary key and foreign key? Give an example

TCS,

4 9933

How to connect PK and FK?

2 6155

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

CMS,

5 8524

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

HP,

2017

what is an sql server?

1 4348

find 2nd highest salary of person using cursor concept?

HCL,

6 12118

how to find the second salary?

HCL, Prithvi,

10 13364

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

9 17842

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

IBM,

2 5342

Un-Answered Questions { SQL Server }

Can you type more than one query in the query editor screen at the same time?

1073

Explain different backup plans?

1007

What is blocking?

1137

What are trace flags?

1088

What are parameterized reports?

204

Explain about temporary stored procedure?

1100

What is row-level compre?

1051

How to fine-tune reports?

279

optimization techinques

2722

What are the steps you must follow to hide sql server instances?

1033

Can you please explain the difference between primary keys and foreign keys?

1173

What will happen if a column containing char type data is changed to the nchar data type?

1157

What happens to a statement batch if there is a compilation error?

1013

What the different types of Replication and why are they used?

1133

explain different levels of normalization? : Sql server database administration

1051

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