Capgemini Interview Question

Asked about the trigger in oracle joins . After that technical questions regarding plsql