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 ?    3 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 is transaction ? Give me one example. Melstar7
What is the difference between a local and a global variable?  3
i need some interview questions on sql server developer plz any onee send some links.  1
How to delete duplicate records from a table?(for suppose in a table we have 1000 Records in that we have 200 duplicate Records , so ,how to findout that duplicate Records , how to delete those Records and arranged into sequence order? one more thing that there is no primary key at all) McAfee4
Can you explain the role of each service?  1
What is the use of CASCADE CONSTRAINTS?  2
What is blocking and how would you troubleshoot it?  1
What is the difference between DTS and SSIS? Allianz3
About Indexed Views? with example? plz reply...  2
What is the default value of CHAR type? Bosch8
What are three SQL keywords used to change or set someone?s permissions?  3
how to delete duplicate rows from table in sql server HCL8
there is a table having two columns no and name and the data is 1 A 2 B 3 C write a query that will result a horizontal output A,B,C vsworx7
Can we rewrite subqueries into simple select statements or with joins? Example? ASD1
How to write query to Delete the records in child table and corresponding records in parent table Semantic-Space8
What are cursors?  8
how to know description of a table in sqlserver 2000  7
I have a huge amount of data which is displayed in a report. The data is viewed every day. Every day the data is displayed in 30 secs but suddenly today it is giving an timeout message today. Data has not been changed. The situation is same as yesterday. What might be the reason??? Please Answer. Satyam4
How can you get @@error and @@rowcount at the same time?  5
What is the order in which the SQL query is executed? list them in order. CTS1
 
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