Domanda di colloquio di Capgemini

What is basic difference between procedure and function.? What is cursor and why we use cursor? What is analytical functions? what is trigger and how many triggers we can create? What is the difference between truncate and delete? what is Dynamic sql? what is the join and its type ?