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
what is physical sort data and logical sort data in index?
 Question Submitted By :: Prasadhari_m@yahoo.com
I also faced this Question!!     Rank Answer Posted By  
 
  Re: what is physical sort data and logical sort data in index?
Answer
# 1
When you create Clustered Index data is physically sorted 
based on the column used in clustered index.

don't know what is logical sort data.
 
Is This Answer Correct ?    0 Yes 0 No
Monal
 
  Re: what is physical sort data and logical sort data in index?
Answer
# 2
As it is explained in the Answer #1, The Clustered Index
uses the Physical Sorting, just like the Page Index at the
Beginning of your book, but The Logical sorting means it
will be done with the Non Clustered Indices, as you all know
the data in the server stored on the multi page files,
because the amount of data stored on the database is huge,
So in case of the logical sorting depending upon say query
results the records are at your disposal which you have got
after filtering using a where clause, then the data is
coming from different pages and there is no continuation
like SNO column in case case of select *, So the pages where
the desired data is found are actually will hold the
references, means the record say #3, from page #3, will hold
the address of the Previous record address as well as the
next record address just like your Double Linked List Nodes,
I hope now logical sorting is explained by me here.
 
Is This Answer Correct ?    1 Yes 0 No
Rajesh B Patil
 
 
 

 
 
 
Other SQL Server Interview Questions
 
  Question Asked @ Answers
 
What is difference beteen Migration and Upgrdation? Satyam4
How to retrieve data from log files in SQL SERVER ?????  1
What about UPDATESTATISTICS ? Intelligroup2
Delete duplicate rows from a table without primary key by using a single query Table Employee empname salary A 200 B 300 A 200 C 400 D 500 D 500 Output should be A 200 B 300 C 400 D 500  2
what is meant by sql injection with example and one more question how to catch the errors in sqlserver  1
What is the diff between Dynamic queries and static queries ICS-Integrated-Computer-Solutions1
how to find number of columns in a table in sql server 2000 and 2005 also Virtusa11
HOW TO FIND THE EMPLOYEE DETAILS WHO ARE GETTING SAME SALARY IN EMP TABLE TCS16
please tell me the query to get details of the employee having the second largest salary 247Customer8
write the query for taking database backup in sql Logica-CMG6
can anybody tell us, how to select 2nd max salary from table. my id is ashish.akk@gmail.com Symphony21
What is a cursor in SQL Server 2000 and their types?  4
The Difference between 'Count' and 'Count(*)'  12
How do you know which index a table is using?  4
how to delete duplicate rows from table in sql server HCL8
I am having table Title with TITLE id,Author ID, Publiser ID , table AUTHOR with Author ID, Author Name, table PUBLISER with Pub ID, Pub name Here hot to find out the publiser id who have relesed the books of patriticular author?  3
What is the difference between local table and global table Polaris1
what is Constraint? How many types of constraints in SQL ? NIIT7
how to get the rowid/rownumbes of a table in sqlserver IBM5
Can we create a clustered index on composite primary key.  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