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 6114

What are the types of model in sql server and explain

TCS,

2 6350

Wht is the difference between stored procedure and trigger

HCL, TCS,

6 14655

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

CTS, TCS,

4 13608

What is the difference between login and a user?

CTS, TCS,

13 30898

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

Value Labs,

4 8335

what is IDE,DMV in sql server?

Value Labs,

1 8582

Wht is Stuff in sql ser

2 5263

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

8 11808

what is the diffrence between Snap Shot and Transaction Replication

CSC,

2 11918

What is the default value of CHAR type?

Bosch,

10 21229

How to find the last update record in SQL Server?

4 16968

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 11560

Can we create a clustered index on composite primary key.

IGT,

3 19443

what is hash table

ILFS, Teledata,

3 20443

Un-Answered Questions { SQL Server }

When would you use it?

951

you accidentally delete the msdb database what effect does this have on your existing sql databases, and how do you recover? : Sql server administration

1205

How to execute a stored procedure in ms sql server?

1088

What is the difference between for xml raw and for xml auto?

991

What are the joins in sql server? : sql server database administration

975

How to view existing indexes on an given table using sys.indexes?

1047

What is field in algebra?

987

what does the automatic recovery do? : Sql server administration

972

What is resource governor in sql server?

954

How do I find the port number for sql server?

932

What is isnull() operator?

982

how can a database be repaired? : Sql server administration

935

What is sqlservr.exe - process - sql server (sqlex?press)?

1063

Do you know what is fill factor and pad index?

947

What are the dis_advantages of stored procedures, triggers, indexes?

2186

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