SQL Server Interview Questions
Questions Answers Views Company eMail

How do you optimize Sql queries ?

Cognizant,

1127

Rate yourself in .NET and SQL ?

SunGard, HCL, Cognizant,

1 5514

in tabase table having a column in it empname field is there which having 5 duplicate values is there i want deleted all the duplicates i want showing only one name only.

7 5384




How do you implement one-to-one, one-to-many and many-to- many relationships while designing tables?

Symphony, TCS, Credit Suisse, GCU,

4 20758

What's the difference between a primary key and a unique key?

4 4992

What are user defined datatypes and when you should go for them?

1 6014

What is bit datatype and what's the information that can be stored inside a bit column?

1 2989

Define candidate key, alternate key, composite key.

Infosys, Software India,

13 104528




What are defaults? Is there a column to which a default can't be bound?

TCS,

2 5447

What is a transaction and what are ACID properties?

Virtusa, TCS, IBM, Config Systems,

14 63082

Create Index myIndex On myTable(myColumn) What type of Index will get created after executing the above statement

3 5481

Explain Active/Active and Active/Passive cluster configurations

2 13070

What is RAID and what are different types of RAID configurations?

Wipro,

8 22687

What is a deadlock and what is a live lock? How will you go about resolving deadlocks?

Microsoft,

7 39721

What is blocking and how would you troubleshoot it?

2 3171


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.

605


what is package and it uses and how can u call a package

835


Why we need to use secondry database file? though, we can do same work using primary database file also.

4137


What is Lock table in SQL?

199


Hi all, can any one please tell me the difference between sql server 2008 and orace 9i

752






Insert syudents details in table.Current system date &time insert into joining time.How do insert?( in sysdate only return current system date how do add time?)

669


What is the difference between online clustering and Offline clustering?

1175


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., }

1019


OPTIMIZATION OF SP,CURSOR,TRIGGERS

1457


How retrieve field names from the table in SQL through JAVA code?

649


How do we upgrade from SQL Server 6.5 to 7.0 and 7.0 to 2000?

832


How do use Having,Group by,Group function in SQL?

623


System variable and temporary variables

928


can any body tell me how to know the password of current user in sql server

878


1.what is the diff between nolock optimizer and read uncommitted isolation? 2.what is the diff between revoke and deny? 3.what is percieved down time? 4.whether password protection are required for backups?if yes why?if no why? 5.what is fill factor? 6.what is cost analysis? 7.what is mean by piece meal restore? 8.what is 'rowguidcol'? 9.impersonate permission? 10.what is selectivity?

817