Capgemini interview question

Questions about indexes, triggers, stored procs