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,

1882

Rate yourself in .NET and SQL ?

Cognizant, HCL, SunGard,

1 7925

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 8356

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

Credit Suisse, GCU, Symphony, TCS,

4 25757

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

 4 7032

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

 1 7305

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

 1 4108

Define candidate key, alternate key, composite key.

Infosys, Software India,

13 111457

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

TCS,

2 7717

What is a transaction and what are ACID properties?

Config Systems, IBM, TCS, Virtusa,

14 73077

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

 3 7676

Explain Active/Active and Active/Passive cluster configurations

 2 14724

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

Wipro,

8 27384

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

Microsoft,

7 45484

What is blocking and how would you troubleshoot it?

 2 4587

Un-Answered Questions { SQL Server }

What are the indexes in sql server?

496

What are tables in sql server?

524

What is log shipping?

555

What is the user of Primary key?

575

What are the properties and different types of sub-queries?

555




How to read data in a table with "select" statements?

547

What are logical/boolean operations in ms sql server?

534

What is collation sensitivity? Explain different types.

537

When you use @@error and try-catch?

564

What is the difference between SQL notification and SQL invalidation?

580

Does table partitioning improve performance?

527

What is the full meaning of dml?

517

What is default constraint in ms sql server?

528

Explain trigger and trigger types?

544

In one interview...interviewer ask me question pleas tell me sql server architecture.. can any body tell me the sql server architecture with digram

1503

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