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   To Refer this Site to Your Friends   Click Here
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
Can Somebody tell me the difference between Clustered & Non-
Clustered Index??
 Question Submitted By :: Sonia
I also faced this Question!!     Rank Answer Posted By  
 
  Re: Can Somebody tell me the difference between Clustered & Non- Clustered Index??
Answer
# 1
In Clustered Index, the data is physically sorted.
only one Clustered Index is created per table.
The data is stored in heap level of the B-tree.

In non-clustered Index, the physical order of the rows is 
not same as the order of index.
there can be upto 249 non-clustered index per table.
the data is present in the random order but the logical 
ordering is specified by the index.
 
Is This Answer Correct ?    0 Yes 0 No
Vijaya
 
  Re: Can Somebody tell me the difference between Clustered & Non- Clustered Index??
Answer
# 2
The difference between a clustered index and a non-
clustered index is that when you use a clustered index, the 
section of the table that comprises the index has its data 
pages linked differently from those data pages comprising a 
non-clustered index.
 
Is This Answer Correct ?    1 Yes 0 No
Ramesh.P
 
 
 
  Re: Can Somebody tell me the difference between Clustered & Non- Clustered Index??
Answer
# 3
while creating primary key it will create cluster index.
while creating unique key it will create noncluster index
---cluster index it will create only one per table
---Non Cluster index it will create up to 249 per table
--cluster index physical sort the data
--Non cluster index logical sort the data.
 
Is This Answer Correct ?    0 Yes 0 No
Hari
 

 
 
 
Other SQL Server Interview Questions
 
  Question Asked @ Answers
 
1.what is the purpose of using alias name in sql server? with certain example? 2.what is cursor?will u plz explain me in detail with certain example?  3
Can some one please help with a query which will take only max value of a column in a join.  2
can anyone explain me the concept of Serialization in Detail and Clear? plz its urgent i have interview on friday (15th feb)  1
What about UPDATESTATISTICS ? Intelligroup2
What is the difference Between Sql-server 2000 & 2005 Value-Labs2
how we can count records as a group of days like sum of records for(four mondays),(four tuesday)........ in a month. group the column for weekdays.  1
how to get the rowid/rownumbes of a table in sqlserver IBM5
write down the code for "how we delete a table without using of Drop command " ? Sonata2
i want to create procedure for create table in sql server 2005 for example create procedure create_table @table varchar(20) as create @table( id int, name char(20) ) but it will get error what is solution? Aptech4
Explain some DBCC commands?  4
What is bit datatype and what's the information that can be stored inside a bit column?  1
Write a query to delete duplicate records in SQL SERVER Infosys19
can you any body tell me suppose database is suspect mode. how can take to normal? Teledata1
Hi Can any one tell me the Good institute to learn SQL esp for Data Base Testing or SQL from scratch to the proficiency level in Hyederabad and facult also. Thankyou well in advance  6
How m-m relationships are implemented?  1
What is the difference between HAVING clause and the WHERE clause?  4
why cluster and non clusterindex are used in sqlserver 2000? explain with example  1
Explain sp_configure commands, set commands?  3
After using delete statement in sql query to delete some records...to retrieve the deleted records we can get using rollback command but till that where it stores means particular location name i need....(after deleting and rollback ) iGate2
How can count the string ? for ex: If i have string like 'bhaskar' then i need like b:1 h:1 a:2 s:1 k:1 r:1 please give any idea on that TCS5
 
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