Pergunta de entrevista da empresa GoDaddy

Is it better performance-wise to use a cursor in a stored proc?