Cognizant interview question

Index, trigger, save exceptions and few sql queries