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 8494

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

2 18879

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

7 19259

Difference between Cluster and Non-cluster index?

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

32 148238

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

2 9696

Explain DBMS, RDBMS?

6 24101

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

TetraSoft, Wipro,

3 21847

Explain the basic concepts of SQL server architecture?

College School Exams Tests,

2 17248

Explain couple pf features of SQL server

2 6214

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

2940

Explain fundamentals of Data ware housing & OLAP?

2 8548

Explain the new features of SQL server 2000?

1 6390

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

2054

Explain sp_configure commands, set commands?

3 13132

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

CSC,

2 17391

Un-Answered Questions { SQL Server }

What methods do you follow to protect from sql injection attack?

1076

How many types of subqueries are there in sql server?

1040

How to add an address record into adventureworkslt?

1030

what are candidate key, alternate key and composite key? : Sql server database administration

969

What is the purpose of indexing?

1097

Explain in details security in SQL azure?

123

What do you mean by authentication modes in sql server?

1139

Explain what are commit and rollback in sql?

983

Why the trigger fires multiple times in single login?

1285

What is Federation Root Database?

104

Can you explain the disadvantages/limitation of the cursor?

1060

how can u get last observation in an unknown dataset ?

2492

How to install sql server 2005 express edition?

1174

Explain about Joins?

1039

Explain the difference between primary keys and foreign keys?

1107

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