Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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

What are the types of indexes available with SQL Server?

Question Posted / guest

Answers were Sorted based on User's Feedback



What are the types of indexes available with SQL Server?..

Answer / guest

There are basically two types of indexes that we use with
the SQL Server. Clustered and the Non-Clustered.

Is This Answer Correct ?    12 Yes 1 No

What are the types of indexes available with SQL Server?..

Answer / nagabhushan

Indexes are of two types,Clustered Index and non Clustered
Index,when you create Clustee index on tables all the rows
in the tables are stored in the order of the clustered
Index key,So there will one cluster index in the table.Non
Clustered Index have there own storage seperate from the
table data storage.Non Clustered Index is stored in the
form of B-trees.

Is This Answer Correct ?    8 Yes 1 No

Post New Answer

More SQL Server Interview Questions

What are the kinds of subquery?

0 Answers  

How to delete database objects with "drop" statements in ms sql server?

0 Answers  

What is split brain scenario in DB mirroring?

1 Answers  

How do I perform an unattended install of sql server 2000?

0 Answers  

difference between function and procedure

3 Answers   Cognizant, HCL, TCS, Theorem,

What is single-user mode and what are the steps you should follow to start sql server in single-user mode?

0 Answers  

What is the difference between migration and upgradation in sql server?

0 Answers  

How much is a sql server license?

0 Answers  

List the ways in which dynamic sql can be executed?

0 Answers  

How do SQL server 2000 and XML linked?

2 Answers  

Are all views updatable ?

0 Answers   MCN Solutions,

In the primary key have a multiple field or not?

8 Answers   TCS,

For more SQL Server Interview Questions Click Here
Categories