Oracle interview question

Optimization of programs