Oracle interview question

I was asked SQL related questions for the technical portion.