Cognizant interview question

Explain stored procedures in sql