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

How to replace null values in expressions using isnull()?

0 Answers  

Explain the steps to use transact-sql cursor?

0 Answers  

What can be used instead of trigger?

0 Answers   ADITI,

What is the sql case statement used for? Explain with an example?

0 Answers  

Mention the 3 ways to get a count of the number of records in a table.

0 Answers  

What are date and time data types in ms sql server?

0 Answers  

What do you understand by physical_only option in dbcc checkdb?

0 Answers  

List out a number of the wants to setup a SQL Server failover cluster?

0 Answers  

What is the use of RDBMS?

0 Answers   Wipro,

how you can move data or databases between servers and databases in sql server? : Sql server administration

0 Answers  

How to remove duplicate rows from table except one?

0 Answers  

What is the difference between for xml raw and for xml auto?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories