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 6220

What are the types of model in sql server and explain

TCS,

2 6485

Wht is the difference between stored procedure and trigger

HCL, TCS,

6 14842

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

CTS, TCS,

4 13788

What is the difference between login and a user?

CTS, TCS,

13 31491

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

Value Labs,

4 8487

what is IDE,DMV in sql server?

Value Labs,

1 8698

Wht is Stuff in sql ser

2 5361

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

8 12066

what is the diffrence between Snap Shot and Transaction Replication

CSC,

2 12049

What is the default value of CHAR type?

Bosch,

10 21558

How to find the last update record in SQL Server?

4 17117

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 11826

Can we create a clustered index on composite primary key.

IGT,

3 19611

what is hash table

ILFS, Teledata,

3 20560

Un-Answered Questions { SQL Server }

What is use of attributehierarchyenabled? : sql server analysis services, ssas

1242

How to create database with physical files specified in ms sql server?

993

optimization techinques

2674

what is bit datatype? : Sql server database administration

916

What is a transaction and why is it important?

1091

What are the methods used to protect against sql injection attack?

1065

Due to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down?

1326

What is the use of “join” in sql server?

1089

Are semicolons required at the end of sql statements in sql server 2005?

995

What is check constraint in sql server?

1002

Which trace flags are enabled in sql server?

1013

How is sql used in sql server?

1008

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

966

What are the reporting services components?

142

What are orphan records?

932

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