SQL Server Interview Questions
Questions Answers Views Company eMail

How do you optimize Sql queries ?

Cognizant,

1143

Rate yourself in .NET and SQL ?

SunGard, HCL, Cognizant,

1 5571

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 5439




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

Symphony, TCS, Credit Suisse, GCU,

4 20976

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

4 5058

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

1 6058

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

1 3028

Define candidate key, alternate key, composite key.

Infosys, Software India,

13 104718




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

TCS,

2 5514

What is a transaction and what are ACID properties?

Virtusa, TCS, IBM, Config Systems,

14 63349

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

3 5542

Explain Active/Active and Active/Passive cluster configurations

2 13142

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

Wipro,

8 22850

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

Microsoft,

7 39919

What is blocking and how would you troubleshoot it?

2 3209


Post New SQL Server Questions






Un-Answered Questions { SQL Server }

What is Lock table in SQL?

226


in a table is b in column k (manikanta,sivananda,muralidhar) i want result like (mnikanta,sivnanda,murlidhar) please slove it

280


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

895


What is the difference between NOROW and LOCKROW?

1233


How we create SQL Server 2005 Reporting Services ? Give me Sample

887






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?

589


which backup strategy you are following at ur company

963


after migrating the dts packg to ssis by using migrtn wizrd in 2005. iam not able to open ssis pack and getting error. what r those errors? how to resolve?

928


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.

2649


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

854


How you trouble shoot when any job fails

652


sql database suspect We have a sql database that is showing as suspect. How can we recover?

688


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.

338


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

820


plss anybody specify tha constrian management system in dbms

789