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 Check point? Explain in Brief what it will do?

Wipro,

1 6083

What is DAC? what is the use of it?

Wipro,

1 5975

what is Buffer cash and Log Cache? Can you Explain it?

Wipro,

1 8906

hi i am having .mdf file and .ldf file ..how can i get the all table in my .mdf..plz give solution

2 4526

does physical index sort data

1 3875

what type of indexes physically sort data?

3 7350

what is differencial backup?how to work?Anybody explai it?

HCL,

2 4950

what is sql injection in sql server?

TATA,

2 6521

what is node in sql server?

CarrizalSoft Technologies, Google, NIIT, Nittany, TATA,

2 25536

How to store pdf file in sql server?

CarrizalSoft Technologies, College School Exams Tests, TATA,

1 7066

What is difference between stored procedure & function?

CarrizalSoft Technologies, Concept Infoway, TATA,

3 7544

How to Rebuild Master database in sql server 2005.

Wipro,

2 5611

please bar with my english i having a database called tblhallreservation in which res_date is date field has to select all the fields in table deponding on month either has to display all details for the month jan or feb and so on

1 3524

create table with fields ID, reserved_by,res_date res_date is datefield like 2010-03-09 00:00:00.000 from 2005 to 2006 any date assume based on res_date need to slect table and display based on month (full jan details in database irrespective of date and year

3 5198

what is trigger . hw will it use them

TCS,

2 6342

Un-Answered Questions { SQL Server }

What is the name of the Database which IBM mainframe uses?

987

How to send a ssrs report from ssis?

176

What is use of except clause? How does it differ from not in clause?

1020

What is the difference between a local and a global temporary table?

1118

What is a document index?

1028

What is the command used to check locks in microsoft sql server?

1044

How do you rebuild an identity column?

949

What are the restrictions that views have to follow? : SQL Server Architecture

1001

Difference between report and query parameter. Why do we need different type of parameter?

953

What are the different authentication modes in sql server? How can it be changed?

1088

how can you select rexcord(rows) from table A which is not present in Table B . Id being the FK in Table B referencing to ID Table A

1682

what are the new features in SSRS?

134

How to create a stored procedure with a statement block in ms sql server?

1070

Tell me what are cursors and when they are useful?

955

How can you find out which stored procedures are recompiling?

918

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