Reckitt interview question

What are SQL procedures and when can they be used?