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 
WHICH INDEX IS FAST CLUSTER AND NON CLUSTER INDEX
 Question Submitted By :: Jabamit
I also faced this Question!!     Rank Answer Posted By  
 
  Re: WHICH INDEX IS FAST CLUSTER AND NON CLUSTER INDEX
Answer
# 1		 
CLUSTER INDEX BCZ THAT WORK PHYSICALLY(MEANS ALREADY IN DEC 
OR ASC ORDER) BUT NON CLUSTER INDEX WORK DYNAMICALLY.
 
Is This Answer Correct ?    4 Yes 2 No
Jabamit
 
  Re: WHICH INDEX IS FAST CLUSTER AND NON CLUSTER INDEX
Answer
# 2		 
Cluster Index is faster because it has data in the leaf
nodes along with the key. Non cluster on the other hand uses
cluster index key to search the data and therefore
relatively less fast.
 
Is This Answer Correct ?    1 Yes 3 No
Shaurabh Thapa
 
 
 

 
 
 
Other SQL Server Interview Questions
 
  Question Asked @ Answers
 
What are the differences between stored procedure and functions in SQL Server 2000? TCS12
how to delete duplicate rows from table in sql server HCL8
how to copy sysdatabase file from c: Drive to D: Drive in SQL Server. IBM4
How to retrieve data from log files in SQL SERVER ?????  1
Can you link only other SQL Servers or any database servers such as Oracle?  1
1.How to check the backup file details if we do not have access to that folder 2.how to check the backup file size without connecting to the folder IBM1
Explain the basic concepts of SQL server architecture?  2
What is the difference between distinct clause and group by clause? Value-Labs1
Explain some DBCC commands?  4
PC(code, model, speed, ram, hd, cd, price) Find the hard drive sizes that are equal among two or more PCs. APX2
How to work on DTS?what is the main requirement? ivan1
What is the difference between Stored Procedure , Function and Package, 1. how many blocks in Package and what are they. IBM5
what are file groups? Evalueserve3
How do I list the available tables in a database I'm querying?  3
What is BCP? When do we use it?  1
wat will be the sql query to extract only last 3 records from table supose table hving thousands for records  16
What are the different ways of moving data/databases between servers and databases in SQL Server? HCL2
What are explicit and implicit transactions?  2
can any one please send sql quries most used in applications.  1
What are defaults? Is there a column to which a default can't be bound?  2
 
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