Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...



SQL Server Interview Questions
Questions Answers Views Company eMail

What is Check point? Explain in Brief what it will do?

Wipro,

1 4670

What is DAC? what is the use of it?

Wipro,

1 4694

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

Wipro,

1 7332

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

2 2942

does physical index sort data

1 2689

what type of indexes physically sort data?

3 5239

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

HCL,

2 3364

what is sql injection in sql server?

TATA,

2 4410

what is node in sql server?

CarrizalSoft Technologies, Google, NIIT, Nittany, TATA,

2 22994

How to store pdf file in sql server?

CarrizalSoft Technologies, College School Exams Tests, TATA,

1 5245

What is difference between stored procedure & function?

CarrizalSoft Technologies, Concept Infoway, TATA,

3 5189

How to Rebuild Master database in sql server 2005.

Wipro,

2 3884

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 2227

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 3106

what is trigger . hw will it use them

TCS,

2 4363







Un-Answered Questions { SQL Server }

What is Replication?

229


What command is used to rename the database?

205


What is the meaning of resultset type_scroll_insensitive?

158


What is ms sql server service broker?

178


Does partitioning help performance?

186






What is sleeping status in sql server?

177


Do you know what are the restrictions that views have to follow?

200


Thanks to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down?

221


What is onf in normalization form?

226


What are the steps to insert a table?

168


What is the fillfactor concept in indexes?

204


How to transfer an existing table from one schema to another schema in ms sql server?

222


How to maintain a fill factor in existing indexes?

185


What is a matrix in ssrs?

45


State the difference between local and global temporary tables?

191