From: esquel@sommarskog.se   
      
   SUBBU (nsubbu1986@gmail.com) writes:   
   > Hi Expert am not a cheater. i have to learning for these qs.already   
   > learnt sqldba with fullfledge.but now i forget all subj bcz some gap   
   > after learning and spend time in my hometime and some problem is   
   > dre.that'y am asking u. i have some doubts please clarify   
      
   The idea I have with newsgroups and forums is that if you have a   
   specific problem, you should be able to get help. On the other hand,   
   forums and groups are not a place for general education.   
      
   Some of the questions you post have a short answer. Others have answers   
   that could fit an entire book. Short or long that does not matter, not   
   does always the answer as such, but the fact that you have an understanding.   
      
   For instance:   
      
   >> 15. What is the difference between index Re-org and index Rebuild?   
   >   
      
   In an index reorganisation, the index pages are moved around, so that a   
   sequential scan of the index follows the physical order of the disk. But   
   the pages themselves are left untouched.   
      
   When you rebuild an index, the index is reconstructed as if it was created   
   as a new index.   
      
   Good, now you know that and can answer the question at an interview, if   
   you memorise it. But the next question might be that "When would you use   
   one or another", and this you cannot answer without deeper understanding.   
      
   Learning takes time. It helps if you stay focused on one area, and don't   
   run in multiple directions. Hey, there are questions in the set I don't   
   know the full answer to by heart.   
      
      
   --   
   Erland Sommarskog, Stockholm, esquel@sommarskog.se   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)