ZTE interview question

How to optimize oracle sql queries, are there any guidelines?