Barclays Interview Question

some situational questions related to oracle, sql, pl/sql, dbms