Capgemini Interview Question

asp.net page life cycle,prerender event,code to bind database table to grid view,indexes ,triggers,sqlbulkcopy,dropdownlist properties,stuff function in SQL, difference between stored procedure and function