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

What is the difference between a Local temporary table and a Global temporary table? How is each one used?

HCL,

2 17585

What are cursors? Name four types of cursors and when each one would be applied?

Adea Solutions,

3 16978

How do you use DBCC statements to monitor various aspects of a SQL server installation?

1 5961

How do you load large data to the SQL server database?

2 9728

How do you check the performance of a query and how do you optimize it?

1 6591

Can XML be used to access data?

2 2290

What is referential integrity and how is it achieved?

Adea Solutions,

1 9210

What is indexing?

AOL,

1191

What is normalization and what are the different forms of normalizations?

2 12471

Difference between server.transfer and server.execute method?

2 10245

What is better - 2nd Normal form or 3rd normal form? Why?

TCS, TPK,

2 9358

Can we rewrite subqueries into simple select statements or with joins? Example?

ASD Lab,

2 6984

What is a function? Give some example?

3 7907

What is a stored procedure?

3 3779

Difference between Function and Procedure-in general?

6 11612

Un-Answered Questions { SQL Server }

What is BLOCK statements in SQL?

191

How will you know when statistics on a table are obsolete?

152

What are the tables in sql?

170

How can you hide the sql server instances?

133

What is temporal data type?

120

What is the purpose of object explorer and its features? : sql server management studio

146

Please illustrate physical database architecture? : SQL Server Architecture

133

i have made a project i vb.net n created a .exe of it after installing it in to any pc, the database (sql express) is not geting accesed i.e the aplication cuts the link of the database, so plz help in this matter.

981

Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting are possible?

138

What are the options which must be set to allow the usage of optimistic models?

135

when would you go for denormalization? : Sql server database administration

121

what changed between the previous version of sql server and the current version? : Sql server database administration

123

What are the types of dml?

108

What is sql sandbox in sql server?

169

New concepts of sql server 2005 use in your project.

1505

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