Hexaware Technologies interview question

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