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 8286

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

2 18677

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

7 18729

Difference between Cluster and Non-cluster index?

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

32 146201

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

2 9400

Explain DBMS, RDBMS?

6 23701

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

TetraSoft, Wipro,

3 21624

Explain the basic concepts of SQL server architecture?

College School Exams Tests,

2 17022

Explain couple pf features of SQL server

2 6038

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

2837

Explain fundamentals of Data ware housing & OLAP?

2 8346

Explain the new features of SQL server 2000?

1 6234

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

1957

Explain sp_configure commands, set commands?

3 12835

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

CSC,

2 17103

Un-Answered Questions { SQL Server }

Define Joins?

982

Can you edit the .rdl code associated with a linked report?

153

Any one plz send me SQL Server Developer/DBA resume for 4 years experience

2682

How can you append an identity column to a temporary table?

891

What is faster join or union?

1129

How can delete duplicate records in cte in sql server?

921

Write a SQL command to insert and update only a particular field?

1056

What is default port number for sql server 2000?

1003

How to rename databases in ms sql server?

1136

What is cursors?

1112

What is a deadlock and what is a live lock?

959

What happens when unicode strings concatenate with non-unicode strings?

1018

What is the temp table?

877

What are examples of triggers?

1028

What are extended events in sql server?

915

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