Question: what is the acceleration when velocity is 0?
Answer: Here, accelerations deals with the rate of change in velocity, which means you need the change in velocity . In case, if the question means that if the velocity is always 0 then, the acceleration is always zero. But if the final velocity is zero then the acceleration is negative i.e deceleration. That's it.