Société Générale interview question

performance tuning and scenario based questions