Oracle interview question

From Coding and Data Structure