ALLInterview.com :: Home Page KalAajKal.com
 Advertise your Business Here     
Browse  |   Placement Papers  |   Company  |   Code Snippets  |   Certifications  |   Visa Questions
Post Question  |   Post Answer  |   My Panel  |   Search  |   Articles  |   Topics  |   ERRORS new
   Refer this Site  Refer This Site to Your Friends  Site Map  Bookmark this Site  Set it as your HomePage  Contact Us     Login  |  Sign Up                      
tip       Ask Questions on ANYTHING, that arise in your Daily Life at     FORUM9.COM
Google
 
Categories  >>  Software  >>  Databases  >>  SQL Server
 
 


 

 
 Oracle interview questions  Oracle Interview Questions
 SQL Server interview questions  SQL Server Interview Questions
 MS Access interview questions  MS Access Interview Questions
 MySQL interview questions  MySQL Interview Questions
 Postgre interview questions  Postgre Interview Questions
 Sybase interview questions  Sybase Interview Questions
 DB Architecture interview questions  DB Architecture Interview Questions
 DB Administration interview questions  DB Administration Interview Questions
 DB Development interview questions  DB Development Interview Questions
 SQL PLSQL interview questions  SQL PLSQL Interview Questions
 Databases AllOther interview questions  Databases AllOther Interview Questions
Question 
What are the type of Indexes? which one is best, why?
 Question Submitted By :: Kmbkrishnan
I also faced this Question!!     Rank Answer Posted By  
 
  Re: What are the type of Indexes? which one is best, why?
Answer
# 1		 
1. Clustered Index 
2. Non-Clustered Index
 
Is This Answer Correct ?    0 Yes 0 No
S. Sundar
 
  Re: What are the type of Indexes? which one is best, why?
Answer
# 2		 
Hi

1)Clustered Index
2)NON-Clustered INdex

But Clustered index is better than non-clusted 
becoz the searching in clusterd is faster than non-clustered

Arun Pandey
A1Technology
 
Is This Answer Correct ?    0 Yes 0 No
Arun Pandey
 
 
 
  Re: What are the type of Indexes? which one is best, why?
Answer
# 3		 
clusterd and non clusterd
 
Is This Answer Correct ?    0 Yes 0 No
Amit Choubey
 
  Re: What are the type of Indexes? which one is best, why?
Answer
# 4		 
Cluster is faster then non cluster index.We can use only 
one cluster index on one table and we can use more then one 
non cluster index on one table.
 
Is This Answer Correct ?    0 Yes 0 No
Jay Vardhan Singh
 
  Re: What are the type of Indexes? which one is best, why?
Answer
# 5		 
1) Clustered Index
2) Non-Clustered Index

I'm assuming by "which one is best" we mean which has the
faster look ups.  This would be the clustered index since it
is the physical ordering of the rows and the non-clustered
index is like a lookup table.  With the clustered index one
you've found the index you've found your row...
 
Is This Answer Correct ?    0 Yes 0 No
Jeff Jordan
 

 
 
 
Other SQL Server Interview Questions
 
  Question Asked @ Answers
 
What's the maximum size of a row?  4
How To Change Column Ordinal Position in SQL Server 2005 using Query i.e I Want To Add Column at Particular Ordinal Position in SQL Server 2005  2
What is the difference between distinct clause and group by clause? Value-Labs1
what is the main difference between after trigger and instead trigger.  1
How do we get current date in SQL Server 2000, Oracle, MS Access?  11
What types of integrity are enforced by a foreign-key constraint  1
What is an Index? Yardi-Software3
What is Trigger? Misys2
What are constraints? Explain different types of constraints?  6
Lets say due to N/W or Security issues client is not able to connect to server or vice versa. How do you troubleshoot?  1
event classes in sql server Accenture1
How to select nth record from a table? DELL9
What is the difference between IN and EXISTS operators in SQL Server? Intelligroup3
What is user stored procedure & it purpose? Wipro3
please tell me the query to get details of the employee having the second largest salary 247Customer8
How can your resolve deadlocks? IBM3
I have student marks in a student table. I need second highest mark .Then what will the query for this? Wipro23
What is the difference between a local and a global variable?  3
When do you create cluster and noncluster index? Satyam4
Can you have a nested transaction? HCL3
 
For more SQL Server Interview Questions Click Here 
 
 
 
 
 
   
Copyright Policy  |  Terms of Service  |  Help  |  Site Map 1  |  Articles  |  Site Map  |   Site Map  |  Contact Us |   interview questions urls   External Links 
   
Copyright © 2007  ALLInterview.com.  All Rights Reserved.

ALLInterview.com   ::  Forum9.com   ::  KalAajKal.com