Accenture interview question

Q: hints, optimization, indexes, sql