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   interview questions urls   External Links  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
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 ?    0 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
 
what is the query and condition to delete datas in sql server.  1
What are the different types of backup avaible in SQL SErver Emphasis3
Would it be a good idea to create an index on a table that always contains 10 records? Why or why not?  2
How many index keys possible for a table  6
how to copy sysdatabase file from c: Drive to D: Drive in SQL Server. IBM3
Explain the new features of SQL server 2000?  1
About Indexed Views? with example? plz reply...  1
How to find the second largest salary in the emp database and also How to find 3rd,4th and so on ........ in the emp database plz mail the answer @ mak2786@gmail.com Oracle13
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?  1
What is a cursor in SQL Server 2000 and their types?  2
What's the difference between a primary key and a unique key? Wipro7
What is the datatype returned by count(*) Asian-CERC16
How to give a user the option of importing Excel and a delimited text file into a SQL Server Database without manually using SQL DTS? GE1
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.  2
If there is failure during updation of certain rows, what will be the state?  1
What is Deadlock? Satyam2
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 delete particular value in the column of a table.Is it possible or not?if possible give it as in query.  3
What is lock escalation?  1
how to generate XML out of QUERY? McAfee1
 
For more SQL Server Interview Questions Click Here 
 
 
 
 
 
   
Copyright Policy  |  Terms of Service  |  Help  |  Site Map 1  |  Articles  |  Site Map  |   Site Map  |  Contact Us
   
Copyright © 2007  ALLInterview.com.  All Rights Reserved.

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