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 a trigger?

4 8290

What is a view?

6 9384

What is an Index?

Yardi Software,

3 9681

What are the types of indexes available with SQL Server?

Standard Bank,

2 8034

What is the basic difference between clustered and a non-clustered index?

Infogain,

9 38155

What are cursors?

8 11172

When do we use the UPDATE_STATISTICS command?

Deutsche Telekom AG,

4 18871

Which TCP/IP port does SQL Server run on?

2 9951

From where can you change the default port?

3 6964

Can you tell me the difference between DELETE & TRUNCATE commands?

15 25068

Can we use Truncate command on a table which is referenced by FOREIGN KEY?

Shriram,

2 10243

What is the use of DBCC commands?

NA,

4 9287

Can you give me some DBCC command options?(Database consistency check) - DBCC CHECKDB - Ensures that tables in the db and the indexes are correctly linked.and DBCC CHECKALLOC - To check that all pages in a db are correctly allocated. DBCC SQLPERF - It gives report on current usage of transaction log in percentage. DBCC CHECKFILEGROUP - Checks all tables file group for any damage.

iSoft,

2508

Well sometimes sp_reanmedb may not work you know because if some one is using the db it will not accept this command so what do you think you can do in such cases?

2 4706

What is the difference between a HAVING CLAUSE and a WHERE CLAUSE?

World Tech, Yardi Software,

11 29606

Un-Answered Questions { SQL Server }

What is blocking?

1050

Why we should not use triggers?

960

How to make conditional sum in ssrs?

177

What is a subquery in a select query statement in ms sql server?

1122

Who developed sql server?

927

What is logon trigger?

1081

What is primary key and example?

936

What is a not null constraint?

1017

Define constraints and give an example of their use?

1037

Explain system rowset functions?

985

Do you know what are the properties of the relational tables?

1023

What is a performance monitor?

967

What is openrowset sql server?

1119

What is the server name in sql server?

997

What are wait types?

1098

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