Anonymous interview question

Question related to Plsql and mostly scenario based