Pregunta de entrevista de American Express

When does one use stored procedure vs Dynamic SQL while working with RDBMS?