Barclays Interview Question

Questions around indexes and table structures