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 6175

What is DAC? what is the use of it?

Wipro,

1 6050

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

Wipro,

1 8993

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

2 4671

does physical index sort data

1 3951

what type of indexes physically sort data?

3 7472

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

HCL,

2 5071

what is sql injection in sql server?

TATA,

2 6674

what is node in sql server?

CarrizalSoft Technologies, Google, NIIT, Nittany, TATA,

2 25664

How to store pdf file in sql server?

CarrizalSoft Technologies, College School Exams Tests, TATA,

1 7176

What is difference between stored procedure & function?

CarrizalSoft Technologies, Concept Infoway, TATA,

3 7707

How to Rebuild Master database in sql server 2005.

Wipro,

2 5730

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 3598

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 5463

what is trigger . hw will it use them

TCS,

2 6456

Un-Answered Questions { SQL Server }

Can you explain what is the use of custom fields in report?

1105

What is sql server used for?

1101

What is difference between standardization and normalization?

1162

List layers of abstraction microsoft architectured to provide relational db through cloud platform ?

187

if you encounter this kind of an error message, what you need to look into to solve this problem? : Sql server database administration

1041

Explain about integration services of Microsoft SQL server?

1093

between cast and convert which function would you prefer and why?

1021

Do you know sql server 2008 introduces automatic auditing?

1057

How can I add Reporting Services reports to my application?

132

on line cluster can we make if yes tell me the procedure

2070

How to convert a unicode strings to non-unicode strings?

1161

What new changes are being made in SQL Server?

1275

What does asynchronous call backs means?

1237

What is dynamic cursor in SQL SERVER?

1141

What do you mean by an execution plan? Why is it used? How would you view it?

987

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