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 6322

What are the types of model in sql server and explain

TCS,

2 6625

Wht is the difference between stored procedure and trigger

HCL, TCS,

6 15062

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

CTS, TCS,

4 13960

What is the difference between login and a user?

CTS, TCS,

13 32005

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

Value Labs,

4 8664

what is IDE,DMV in sql server?

Value Labs,

1 8814

Wht is Stuff in sql ser

2 5452

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

8 12312

what is the diffrence between Snap Shot and Transaction Replication

CSC,

2 12168

What is the default value of CHAR type?

Bosch,

10 21964

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 12085

Can we create a clustered index on composite primary key.

IGT,

3 19769

what is hash table

ILFS, Teledata,

3 20712

Un-Answered Questions { SQL Server }

What is single-user mode?

986

How many database files are there in sql server 2000?what are they?

1111

What are the disadvantages of using the stored procedures?

1194

Difference between LEN() and DATALENGTH() in sql server ?

1175

Explain about thread and memory management process of SQL?

1023

Explain what are page splits? : SQL Server Architecture

1122

How to create nested stored procedure?

1077

Is sql server difficult to learn?

968

How to write a query with a full outer join in ms sql server?

1164

why would you use sql agent? : Sql server database administration

1272

How to optimize stored procedure optimization?

969

What does select 1 mean?

977

What command would you use to create an index?

1114

What do I need to start working with sql studio? : sql server management studio

1165

what is the Ticketing tool used in Wipro technologies at Bangalore...???

8206

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