Verizon interview questions

I get a call from a recruiter (can't really remember anything about signing up with this recruiter) to go to a 1:1 interview with Verizon Wireless in Alpharetta. I interview with one guy...really nice and he was very casual. We sit down and he not only asks me a bunch of technical questions but wants me to write our sql statements, i.e., inner and outer join statements. Then he quizzes me on unix - specifics too, like 'what editor would you pull up'; 'what steps would you take if you wanted to know this (or that)...a lot more sql statements...group by, etc. that he wanted me to write out...It was very excruciating. So, I can blame the recruiter, who did not prepare me at all. But seriously, unless I am an sql developer, why would I need to know this. I currently run sql statements and know some basics, which I told him. He also said that they are moving around people and teams to be fit people in certain roles to be compliant to SOX (or something)...didn't get the job, needless to say.