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 6190

What is DAC? what is the use of it?

Wipro,

1 6066

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

Wipro,

1 9013

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

2 4722

does physical index sort data

1 3967

what type of indexes physically sort data?

3 7494

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

HCL,

2 5105

what is sql injection in sql server?

TATA,

2 6713

what is node in sql server?

CarrizalSoft Technologies, Google, NIIT, Nittany, TATA,

2 25702

How to store pdf file in sql server?

CarrizalSoft Technologies, College School Exams Tests, TATA,

1 7213

What is difference between stored procedure & function?

CarrizalSoft Technologies, Concept Infoway, TATA,

3 7745

How to Rebuild Master database in sql server 2005.

Wipro,

2 5760

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 3625

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 5505

what is trigger . hw will it use them

TCS,

2 6486

Un-Answered Questions { SQL Server }

Is it possible to have clustered index on separate drive from original table location?

1033

Why and when do stored procedure recompile?

1047

What is clustered index

1079

If any stored procedure is encrypted, then can we see its definition in activity monitor?

1058

Where can you add custom error messages to sql server?

1195

What is sql server query analyzer?

1114

What is an indexed view?

1016

How do I find query history in sql server?

1017

What is the difference between upgrade and migration in sql server?

1169

Why use identity in sql server?

1185

How do I start sql server 2017?

1005

If you're given a raw data table, how would perform etl (extract, transform, load) with sql to obtain the data in a desired format?

1041

What are the source of constraints?

1001

How to enter binary string literals in ms sql server?

1234

Can you index views?

951

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