Oracle Interview Question

dbms optimization techniques to use