Oracle interview question

Mostly expected questions