eClerx interview question

1. Difference between Rank, Dense Rank, Row Number 2. Package/SP optimization 3. Identify if query written is right or wrong 4. Most scenarion based questions where on For each loop container and Script task