Accenture interview question

Indexing, Stored Procedures, CTE in sql