Procode Technology interview question

Fixing broken code in oracle package and few data modelling queries, it was average