One of the interview question which I would like to highlight was "I have lot of duplicate records in the db which are consuming lot of unnecessary space, what can I do for this" The answer which I told was "delete those duplicate records" Then the linked question was "even after deleting, I still have lot of unnecessary space, wht shd I do" The answer I given was "increase the temp tablespace ". He doesn't know what does this mean..