BNP Paribas interview question

Different joins Index Transaction Exception handling