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                      
Do you have a collection of Interview Questions and interested to share with us!!
Please send that collection to along with your userid / name. ThanQ
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 ?    5 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 ?    5 Yes 0 No
Rajesh
 
 
 

 
 
 
Other SQL Server Interview Questions
 
  Question Asked @ Answers
 
what is physical sort data and logical sort data in index?  1
what is replication? where do u use Go Keyword? Satyam1
how to copy sysdatabase file from c: Drive to D: Drive in SQL Server. IBM3
Name three version of sql server 2000 and also their differences?  1
Can you link only other SQL Servers or any database servers such as Oracle?  1
What is the difference between two queries: 1. SELECT * FROM table WHERE 1=1; 2. SELECT * FROM table HP12
Which is better in performance - CONSTRAINT or TRIGGER over a column which restricts say an input of particular value in a column of a table? Accenture3
create index a on employee(dno) In this,which index was created?  1
What are functions  3
is it possible to use a variable in a query with the IN clause (a,b,c..z), without getting quotes or conversion errors?  1
What are the types of backup and tell me the difference between full and differential backup? TCS3
What is BCP? When do we use it?  1
What are the type of Indexes? which one is best, why?  5
What value could be assigned to Varchar Type?  2
what is meant by sql injection with example and one more question how to catch the errors in sqlserver  1
what is extended StoreProcedure ? Satyam3
What is the difference between distinct clause and group by clause? Value-Labs1
wat will be the sql query to extract only last 3 records from table supose table hving thousands for records  14
How will u get 5 years back record?  3
how to select a field with firstletter as capital and remaining are small letters  7
 
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