Infosys interview question

Cursor and refcursor. Joins Indexes