Only asked questions on performance tuning in depth not asking any query on sql coding.. To anser questions we need to read performance tuning book. He will ask you to tell him complete execution plan of query he given not satisfied if you anwered with components like index seek and index scan.