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 the main difference between constraints(like primary key etc..)& joins?

2 6323

What are the types of model in sql server and explain

TCS,

2 6627

Wht is the difference between stored procedure and trigger

HCL, TCS,

6 15066

What are the types of backup and tell me the difference between full and differential backup?

CTS, TCS,

4 13962

What is the difference between login and a user?

CTS, TCS,

13 32013

What is the use of placing primary key and foreign key constrains on columns.

Value Labs,

4 8665

what is IDE,DMV in sql server?

Value Labs,

1 8816

Wht is Stuff in sql ser

2 5453

how to get 25th row in any table in sqlserver can u tell me syntax

8 12317

what is the diffrence between Snap Shot and Transaction Replication

CSC,

2 12170

What is the default value of CHAR type?

Bosch,

10 21968

How to find the last update record in SQL Server?

4 17269

I have a table in which phno is one of the columns.i do have some values in tht phno column.i need to update phno column values with 0(zero) as prefix.give me a correct solution plz...

Value Labs,

7 12090

Can we create a clustered index on composite primary key.

IGT,

3 19772

what is hash table

ILFS, Teledata,

3 20713

Un-Answered Questions { SQL Server }

What do you mean by a Composite primary key?

1196

Explain steps of normalization?

1069

what's the maximum size of a row? : Sql server database administration

1167

How do I get to sql server configuration manager?

1068

What is difference between oltp and olap?

1100

Explain Capacity planning to create a database? and how to monitor it?

4252

how you can deploy an ssrs report?

185

What is the purpose of the master database?

1210

Explain where clause?

1040

What is nolock hint in sql server 2008

1185

What triggers long term care?

1096

What is the difference between for auto and for nested?

1071

Tell me the use of keyword with encryption. Create a store procedure with encryption?

1065

Why is normalisation important?

989

Relational calculus is what type of language?

1100

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