Nabla Infotech Interview Question

How SQL stored procedures works?