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 is the basic difference between clustered and a
non-clustered index?
 Question Submitted By :: Guest
I also faced this Question!!     Rank Answer Posted By  
 
  Re: What is the basic difference between clustered and a non-clustered index?
Answer
# 1
The difference is that, Clustered index is unique for any
given table and we can have only one clustered index on a
table. The leaf level of a clustered index is the actual
data and the data is resorted in case of clustered index.
Whereas in case of non-clustered index the leaf level is
actually a pointer to the data in rows so we can have as
many non-clustered indexes as we can on the db.
 
Is This Answer Correct ?    17 Yes 1 No
Guest
 
  Re: What is the basic difference between clustered and a non-clustered index?
Answer
# 2
I am explaining you with an example, The Telephone 
Directory is a fine example of Clustered Index as data and 
index are at the same page, whereas index in the back side 
of the book is a fine example of non-clustered index and 
non-clustered index is a fast B-tree structure as index 
just points to the data page. Also only one clustered index 
is possible per table and 249 non-clustered index per table.
 
Is This Answer Correct ?    20 Yes 0 No
Rajesh
 
 
 
  Re: What is the basic difference between clustered and a non-clustered index?
Answer
# 3
clustered index one in table nad non-clustered index may be 
more than one in one table.
 
Is This Answer Correct ?    2 Yes 0 No
Anil Sharma
 

 
 
 
Other SQL Server Interview Questions
 
  Question Asked @ Answers
 
i have table students with fields classname,studname select * from students classname studname 1 xxxxx 1 yyyy 1 zzzz 2 qqqq 2 tttt 3 dsds 3 www i want the output should be No of students in class 1 : 3 No of students in class 2 : 2 No of students in class 3 : 2 HCL2
How to Execute an Operating System Command From Within SQL Server ?  2
can you any body tell me simple recovery,full recovery,bulk logged recovery where can use?  1
If there exist a index on the table, and we then make a view on that table (include the indexed column from base table) than why do we require indexing on view?Doesnt it create an overhead?  1
What is the difference between a Local temporary table and a Global temporary table? How is each one used?  1
Is it possible to have more then one foreign key in a single table? if possible, is this the good way to design the table?  2
how to get the rowid/rownumbes of a table in sqlserver IBM5
what is web server? Satyam3
What are the types of model in sql server and explain TCS1
Where do you think the users names and passwords will be stored in sql server?  3
How are SQL Server databases physically stored under Windows 2000?  1
what is Archive old data?  1
How do we rollback the table data in SQL Server  3
Please get the 4 th maximum salary from a table without using any sql keyword (TOP,MAX are mot allowed)  5
SQL stops working in every 15 days displaying message that database log file is full. Log file size is 3.95 GB. It is happening after shrinking the database also. What is solution to overcome this problem. Please help me as it's urgent.  5
explain different types of jions with examples briefly? Zensar3
Explain Active/Active and Active/Passive cluster configurations  1
what is advantages in sql 2005 over sql 2000?  4
how to count datewise data in sqlserver IndusInd-Bank3
What are the type of Indexes? which one is best, why?  5
 
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