GE interview question

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