Pregunta de entrevista de GE

I was asked mainly basic SQL questions - differences between join queries, indexes, procedures