Hi GilaMonster,

Thanks a lot for taking time to review them. The test says if you don't find correct answer in the given options, guess /choose the one which is more near to the correct answer and i was trying to do that. so it might help me if i had to take the test again.

I went through few BOL topics (Transaction Log Truncation, Over Clause, Create Login, etc) and books to find these answers and thought they might be an option near to right one.

Regarding sorting order, i went through the BOL over clause and tested on a table created my self and it worked. so i thought it might be true.

Coming to full text indexes there is a book "Mastering SQL Server 2008 By Michael Lee, Gentry Bieker" on page 626, chapter 21, second para of the new alter feature box, it is stated that FTI's are backed up with every SQL Server Back up processes because they are included in the standard catalog

so again with minimal knowledge about it, i assumed it to be true.

your help is greatly appreciated and thanks for your tip Don't confuse 'will usually work the way you want' with 'is guaranteed to work the way you want'., will keep it in mind

Thanks and Regards

DK