SQL Server Interview Questions
Questions Answers Views Company eMail

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

Wipro,

1 3888

What is DAC? what is the use of it?

Wipro,

1 4129

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

Wipro,

1 6129




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

2 2350

does physical index sort data

1 2113

what type of indexes physically sort data?

3 4344

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

HCL,

2 2788

what is sql injection in sql server?

TATA,

2 3636




what is node in sql server?

Google, NIIT, TATA, CarrizalSoft Technologies, Nittany,

2 20422

How to store pdf file in sql server?

TATA, CarrizalSoft Technologies, College School Exams Tests,

1 4655

What is difference between stored procedure & function?

TATA, CarrizalSoft Technologies, Concept Infoway,

3 4401

How to Rebuild Master database in sql server 2005.

Wipro,

2 3247

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 1742

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 2350

what is trigger . hw will it use them

TCS,

2 3656


Post New SQL Server Questions






Un-Answered Questions { SQL Server }

Hi, I Created 3 Tables Person(PersID[prkey],Name,Email,Password), Project(ProjName,ProjID[prkey],ProjLeader,ProjManager) & ProjectInvolvement(EntryDate,ProjID[frkey],PersID[frkey],ProjDuration). For this how can i INSERT,UPDATE & DELETE Through PROCEDURE? Please Post the Answer for me. Desai.

664


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?

1254


What is RMS migrations?

953


IF more than one Site is accessing the same Database server and I want to move the DB with Minimum down time? How will you do

655


how to take backup bcp out for a column in table in sql server?

854






How to check what was the last restore transaction LSN in Log shipping or Mirroring? when we don't have a Monitor or witness server.

2680


How should i optimize the time for execution of stored procedure having single input and many output from the different tables?

816


How do I repair damaged sql server mdf file database? In previous day my mdf file has got damage due to unknown reasons then I used dbcc chekcdb command but it failed, MDF file is important for me, I don’ know that how to get back mdf file data. Please anyone suggest me?

611


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

1309


Explain Capacity planning to create a database? and how to monitor it?

2801


your distribution database is full what will u do

956


If the job running very slow what is the action you do

713


how to do partition in sqlserver

1303


what is the sql equivaent of the dataset relation object ?

843


i have made a project i vb.net n created a .exe of it after installing it in to any pc, the database (sql express) is not geting accesed i.e the aplication cuts the link of the database, so plz help in this matter.

705