1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category


SQL Server Interview Questions
Questions Answers Views Company eMail

How do you optimize Sql queries ?

Cognizant,

1963

Rate yourself in .NET and SQL ?

Cognizant, HCL, SunGard,

1 8099

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 8739

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

Credit Suisse, GCU, Symphony, TCS,

4 26064

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

 4 7302

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

 1 7506

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

 1 4229

Define candidate key, alternate key, composite key.

Infosys, Software India,

13 112328

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

TCS,

2 8000

What is a transaction and what are ACID properties?

Config Systems, IBM, TCS, Virtusa,

14 73960

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

 3 7932

Explain Active/Active and Active/Passive cluster configurations

 2 14912

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

Wipro,

8 27896

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

Microsoft,

7 45996

What is blocking and how would you troubleshoot it?

 2 4754

Un-Answered Questions { SQL Server }

What is the difference between stored procedure and functions?

664

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

1652

Issues related in upgrading SQL Server 2000 to 2005 / 2008

1590

What are the 3 types of schema?

677

Explain stored procedure?

671




What are cursors stored procedures and triggers?

581

Can we call future method from trigger?

590

what is the sql equivaent of the dataset relation object ?

1650

How to test subquery results with the exists operator?

637

What do you understand by a stored procedure?

699

Does server sql treat char as a variable-length or fixed-length column?

667

How to specify the collation for a character data type in ms sql server?

641

Is a null value equal to anything? Can a space in a column be considered a null value? Why or why not?

710

How do I view a trc file?

585

Write a SQL query to make a column as unique?

697

For More Un-Answered { SQL Server } Questions Click Here