SQL Server Interview Questions
Questions Answers Views Company eMail

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

Wipro,

1 5254

What is DAC? what is the use of it?

Wipro,

1 5251

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

Wipro,

1 8155

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

2 3533

does physical index sort data

1 3262

what type of indexes physically sort data?

3 6273

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

HCL,

2 4001

what is sql injection in sql server?

TATA,

2 5289

what is node in sql server?

CarrizalSoft Technologies, Google, NIIT, Nittany, TATA,

2 24345

How to store pdf file in sql server?

CarrizalSoft Technologies, College School Exams Tests, TATA,

1 6026

What is difference between stored procedure & function?

CarrizalSoft Technologies, Concept Infoway, TATA,

3 6092

How to Rebuild Master database in sql server 2005.

Wipro,

2 4652

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 2725

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 3985

what is trigger . hw will it use them

TCS,

2 5121


Un-Answered Questions { SQL Server }

What is the difference between writing data to mirrored drives versus raid5 drives

494


how many layers of tcp/ip protocol combined of? : Sql server database administration

503


what are defaults? Is there a column to which a default can't be bound? : Sql server database administration

609


Explain what are the restrictions that views have to follow? : SQL Server Architecture

576


Can you move the resources after pausing the node? : sql server database administration

581






let's assume you have data that resides on sql server 6.5. You have to move it sql server 7.0. How are you going to do it? : Sql server database administration

491


Can I run multiple instances of sql server 2000 at the same time on one computer?

581


What are the different types of collation sensitivity?

539


Explain error handling in ssis?

559


When you use @@error and try-catch?

559


What happens if date-only values are provided as date and time literals?

525


What are basics of policy management?

591


what is a transaction and what are acid properties? : Sql server database administration

516


What is the command dbcc checkdb used for?

524


What is master database? : SQL Server Architecture

518