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 5971

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

Wipro,

1 8898

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

2 4509

does physical index sort data

1 3871

what type of indexes physically sort data?

3 7346

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

HCL,

2 4948

what is sql injection in sql server?

TATA,

2 6511

what is node in sql server?

CarrizalSoft Technologies, Google, NIIT, Nittany, TATA,

2 25521

How to store pdf file in sql server?

CarrizalSoft Technologies, College School Exams Tests, TATA,

1 7060

What is difference between stored procedure & function?

CarrizalSoft Technologies, Concept Infoway, TATA,

3 7528

How to Rebuild Master database in sql server 2005.

Wipro,

2 5605

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 3519

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 5190

what is trigger . hw will it use them

TCS,

2 6332

Un-Answered Questions { SQL Server }

what are the reporting service components in SSRS?

163

How do you handle datasets larger than 50 gb?

162

What is database replication? What are the different types of replication you can set up in sql server?

956

How to view existing indexes on an given table using sys.indexes?

1088

What is a fill factor?

1080

explain what are the steps you will take, if you are tasked with securing an sql server? : Sql server database administration

1092

You schedule a job to run every minute what will happen if the first job runs more than 1 min? Will the second instance of the job start?

1032

What is the use of sign function?

1114

Explain transaction server consistency?

964

what type of index will get created after executing the above statement? : Sql server database administration

971

What is the difference between for xml raw and for xml auto?

1028

What is the use of keyword with encryption.

1026

what is an extended stored procedure? Can you instantiate a com object by using t-sql? : Sql server database administration

1016

Do you know the capabilities of cursors?

1143

How many types of objects are there?

1002

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