Domanda di colloquio di Capgemini

What is trigger, procedure, function, package, indexes and how it works ?