American Express interview question

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