Cognizant Associate interview questions

They had 2 technical round n hr round. They ask questions based on your cv. Just be thorough with it. Had walk-in in 2015 had to wait a lot for getting called for interview.

1) What do you understand by a stored procedure? 2) Mention the uses of stored procedures. 3) What are the types of stored procedures in an SQL server? 4) What are the advantages of using a stored procedure? 5) What are the disadvantages of using the stored procedures? 6) How will you optimize a stored procedure optimization? 7) What are the differences between stored procedure and view in SQL server? 8) List some major differences between triggers and stored procedures? 9) What do you understand by recursive stored procedures? 10) When would you use the stored procedures or functions?