Can retired galaxies mimic active galaxies? Clues from the Sloan Digital Sky Survey