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 8382

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

2 18748

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

7 18950

Difference between Cluster and Non-cluster index?

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

32 146935

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

2 9513

Explain DBMS, RDBMS?

6 23860

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

TetraSoft, Wipro,

3 21716

Explain the basic concepts of SQL server architecture?

College School Exams Tests,

2 17110

Explain couple pf features of SQL server

2 6107

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

2874

Explain fundamentals of Data ware housing & OLAP?

2 8448

Explain the new features of SQL server 2000?

1 6298

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

1982

Explain sp_configure commands, set commands?

3 12973

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

CSC,

2 17228

Un-Answered Questions { SQL Server }

Is it possible to update the views? If yes, how, if not, why?

1018

Explain a differential backup?

1001

What do you do in data exploration

983

What is report snapshot in ssrs?

266

Explain about SQL server 2005?

965

What is a schema in ms sql server 2005?

960

What is table join?

1109

How use inner join in sql server?

1120

Can two tables have the same primary key?

1198

How optimize sql query with multiple joins in sql server?

890

Does group by sort data?

888

How to edit table in sql server 2017?

920

How can I create a report based on a query? : sql server management studio

1014

How to create “dependant” parameter “make, model, year”

131

Can a trigger be created on a view?

950

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