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,

1825

Rate yourself in .NET and SQL ?

Cognizant, HCL, SunGard,

1 7812

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 8099

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

Credit Suisse, GCU, Symphony, TCS,

4 25517

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

 4 6873

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

 1 7225

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

 1 4020

Define candidate key, alternate key, composite key.

Infosys, Software India,

13 110934

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

TCS,

2 7549

What is a transaction and what are ACID properties?

Config Systems, IBM, TCS, Virtusa,

14 72416

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

 3 7531

Explain Active/Active and Active/Passive cluster configurations

 2 14611

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

Wipro,

8 27117

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

Microsoft,

7 45168

What is blocking and how would you troubleshoot it?

 2 4471

Un-Answered Questions { SQL Server }

You want to use a perspective in an mdx query. How do you select the perspective?

106

How many types of triggers are there?

496

plss anybody specify tha constrian management system in dbms

1477

What is an execution plan? When would you use it?

509

Differentiate between ms sql server reporting services vs crystal reports?

420




How global temporary tables are represented and its scope?

487

How to round a numeric value to a specific precision?

495

What is policy based management (pbm)? : sql server database administration

525

What are information schema views?

479

What is the current limitation of the size of SQL Azure DB?

98

Suppose you want to implement the following relationships while designing tables. How would you do it?a.) One-to-oneb.) One-to-manyc.) Many-to-many

459

What is multilevel indexing?

466

How much does sql server 2016 cost?

458

What is dbcc updateusage?

479

What are the differences between decimal and float in ms sql server?

504

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