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 18994

Difference between Cluster and Non-cluster index?

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

32 147060

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

2 9537

Explain DBMS, RDBMS?

6 23886

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 17121

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?

1990

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 }

Can we do dml on views?

952

Does a specific recovery model need to be used for a replicated database? : sql server replication

961

How do you trace the traffic hitting a sql server?

1141

What are pages and extents? : SQL Server Architecture

1017

What is single-user mode?

940

What are the kinds of subquery?

1008

What is the template in sql?

978

List down some advantages of sql stored procedure?

963

What is the difference between push and pull subscription? : sql server replication

1216

Write SQL queries on Self Join and Inner Join.

1154

What is the difference between indexing and hashing?

1169

When a primary key constraint is included in a table, what other constraints does this imply?

989

What is the difference between sdf and mdf?

1300

What are out-of-range errors with date and time literals?

1030

Explain trigger and trigger types?

980

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