Oracle interview question

This is question 2 for oracle