Novacoast Software Engineering Intern interview questions

I was contacted pretty quickly (< 2 weeks) after meeting a recruiter at the career fair at school. We then scheduled a time to meet for an in person interview within the next few days. It was 1 interview with a Software Engineer and the VP of Development, Eron Howard. First we went over what I knew about the company and what I was looking for, then we went over my resume and they asked me about projects, and then there was the technical part. They handed me a sheet of paper with various pieces of code. They asked me to explain what each thing did. The code/problems ranged from important unix files like fstab and stuff, some kind of database query that I wasn't familiar with, something about a SQL join, etc. Just kind of random stuff all on 1 page. I mostly didn't know and couldn't quite comment on anything too specifically so that was definitely my downfall...