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 6167

What is DAC? what is the use of it?

Wipro,

1 6042

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

Wipro,

1 8989

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

2 4660

does physical index sort data

1 3949

what type of indexes physically sort data?

3 7466

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

HCL,

2 5061

what is sql injection in sql server?

TATA,

2 6670

what is node in sql server?

CarrizalSoft Technologies, Google, NIIT, Nittany, TATA,

2 25659

How to store pdf file in sql server?

CarrizalSoft Technologies, College School Exams Tests, TATA,

1 7167

What is difference between stored procedure & function?

CarrizalSoft Technologies, Concept Infoway, TATA,

3 7698

How to Rebuild Master database in sql server 2005.

Wipro,

2 5723

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 3593

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 5450

what is trigger . hw will it use them

TCS,

2 6448

Un-Answered Questions { SQL Server }

What is cdc in sql server?

1046

How do I debug a stored procedure in sql server?

1178

How to create new table with "create table" statements?

1193

What are the advantages of log shipping?

1039

Describe different Processing Modes offered by SSRS?

256

Tell me what is de-normalization and what are some of the examples of it?

1098

Explain transaction server distributed transaction?

1039

You want to implement the one-to-one relationship while designing tables. How would you do it?

1013

1.what is the diff between nolock optimizer and read uncommitted isolation? 2.what is the diff between revoke and deny? 3.what is percieved down time? 4.whether password protection are required for backups?if yes why?if no why? 5.what is fill factor? 6.what is cost analysis? 7.what is mean by piece meal restore? 8.what is 'rowguidcol'? 9.impersonate permission? 10.what is selectivity?

2125

How to create a simple stored procedure in ms sql server?

1089

Explain the use of containers in ssis?

1016

What is resource governor?

1032

What is a collation in ms sql server?

1136

Explain cross join or cartesian product in sql?

928

Difference Between ORDER BY Clause and GROUP BY Clause in SQL?

1104

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