Frage im Vorstellungsgespräch bei GE

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