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 8395

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

2 18774

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

7 18996

Difference between Cluster and Non-cluster index?

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

32 147065

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

2 9538

Explain DBMS, RDBMS?

6 23888

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

TetraSoft, Wipro,

3 21728

Explain the basic concepts of SQL server architecture?

College School Exams Tests,

2 17122

Explain couple pf features of SQL server

2 6117

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

2878

Explain fundamentals of Data ware housing & OLAP?

2 8450

Explain the new features of SQL server 2000?

1 6313

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

1991

Explain sp_configure commands, set commands?

3 12988

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

CSC,

2 17246

Un-Answered Questions { SQL Server }

Which table keeps the locking information?

922

Can we use where clause in union?

1066

What is difference between materialized view and view?

915

How can sql injection be stopped? : sql server security

1034

What are parameterized reports?

200

What is checkpoint in sql server?

1157

Explain the various types of concurrency problem?

1193

How to check status of stored procedure in sql server?

986

What are functions in the sql server?

1217

Which tcp/ip port does the sql server run on? How can it be changed?

1052

What is the use of =,==,=== operators?

1013

What is page in sql server?

947

If you're given a raw data table, how would perform etl (extract, transform, load) with sql to obtain the data in a desired format?

967

How to replace given values with null using nullif()?

987

What new changes are being made in SQL Server?

1186

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