Cognizant interview question

Design patterns and SQL Performance