Nabla Infotech interview question

How SQL stored procedures works?