Hexaware Technologies Interview Question

mostly on SQL TUNING. partitioning and indexing bulk collect ref cursor periodic commit