To re-emphasize what Bob said, without destroying the tape I don't think you can ever consider it secure to the point at which data cannot be taken off of it. Where there's a will, there's a way!
As far as the quick and long erase in NBU, the quick erase mearly erases the header information. Anyone with enough knowledge of what they're doing can easily get data off of that tape.
Again, all depends on how "secure" you want it...