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

Can a stored procedure call another stored procedure. If yes what level and can it be controlled?

2 8502

Can a stored procedure call itself(recursive). If yes what level and can it be controlled.?

2 18893

How do you find the number of rows in a table?

7 19304

Difference between Cluster and Non-cluster index?

Accenture, Agility e-Services, eClinicalWorks, HCL, Infosys, Oracle, Satyam, Yardi,

32 148449

What is a table called, if it does not have neither Cluster nor Non-cluster Index?

2 9716

Explain DBMS, RDBMS?

6 24136

Explain basic SQL queries with SELECT from where Order By, Group By-Having?

TetraSoft, Wipro,

3 21870

Explain the basic concepts of SQL server architecture?

College School Exams Tests,

2 17270

Explain couple pf features of SQL server

2 6224

Scalability, Availability, Integration with internet, etc.)?

1 2940

Explain fundamentals of Data ware housing & OLAP?

2 8562

Explain the new features of SQL server 2000?

1 6403

How do we upgrade from SQL Server 6.5 to 7.0 and 7.0 to 2000?

1 2056

Explain sp_configure commands, set commands?

3 13156

What is the basic functions for master, msdb, tempdb databases?

CSC,

2 17409

Un-Answered Questions { SQL Server }

Disadvantages of the indexes?

1207

What is a coalesce function?

1261

How efficient you are in oracle and SQL server?

1235

What is clustered index

1069

Explain system functions or built-in functions? What are different types of system functions?

1053

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

1095

What are the pros and cons of putting a scalar function in a queries select list or in the where clause?

1277

Is there any performance difference between if exists (select null from table) and if exists (select 1 from table)?

1015

What are wait types?

1219

What kind of problems occurs if we do not implement proper locking strategy?

1479

What is a scheduled job or what is a scheduled task?

1022

Why use identity in sql server?

1185

What is standby servers? Explain types of standby servers.

1067

Why should you use or avoid select * statements?

1094

What is temporary table in sql server? Why we use temp table?

1001

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