SQL Server Interview Questions
Questions Answers Views Company eMail

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

Wipro,

1 3926

What is DAC? what is the use of it?

Wipro,

1 4154

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

Wipro,

1 6193




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

2 2385

does physical index sort data

1 2145

what type of indexes physically sort data?

3 4375

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

HCL,

2 2806

what is sql injection in sql server?

TATA,

2 3672




what is node in sql server?

Google, NIIT, TATA, CarrizalSoft Technologies, Nittany,

2 20550

How to store pdf file in sql server?

TATA, CarrizalSoft Technologies, College School Exams Tests,

1 4681

What is difference between stored procedure & function?

TATA, CarrizalSoft Technologies, Concept Infoway,

3 4438

How to Rebuild Master database in sql server 2005.

Wipro,

2 3270

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 1768

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 2371

what is trigger . hw will it use them

TCS,

2 3686


Post New SQL Server Questions






Un-Answered Questions { SQL Server }

1.what are diff types of joins , and explain diff between cross join and full outer join 2.diff types of views 3. Diff types of index 4. What is diff b/w stores procedure and function procedure 5.diff between double and int in SQL 6.diff between char and varchar in SQL. 7.Oracle or SQL whice you will preferred and why.

372


How to restore performance issues and how to check?

861


If user is owning any SQL Objects, can we drop that user

863


What is data modeling and Reterminal integrity?

682


tell me the disaster recovery plan

1302






How do you Implement SSIS Packages in your Project?

848


how do you determine the Load performance of any query in sql server {example how do u determine performance of a select stmnt which returns Dynamically many no of records ... some times 100,1000,10000 etc., }

1069


how to do partition in sqlserver

1324


Does any body please help me what question's have asked for SSRS in the interview?

899


plss anybody specify tha constrian management system in dbms

836


how to use DTS package in 2000,2005,2008 in sql server

797


Any one plz send me SQL Server Developer/DBA resume for 4 years experience

1512


How to write the storeprocedure with in the store procedure? and how can we write the store procedure with in a trigger vice versa? plz post me the exact answer?

1275


1 01 101 01010

766


what exactly sql injuction.how to overcome.....

1321