You know, I’m not entirely sure how that went.
I spoke briefly with my potential supervisor’s supervisor, and that seemed to go well. More of the same: Tell me about the Access tracking database, etc. Then I met with two senior team members, who asked me more technical questions: How many tables were in your database? How many columns in the main table? What kinds of reports did you create?
Then I got the SQL test.
First question: Write pseudocode to generate the first 10 numbers of the Fibonacci sequence: (0,1,1,2,3,5,8,13,21,34)
Took me a second to remember / deduce what the Fibonacci sequence was (add the two previous numbers to get the next number). Then I was all, OK, do while loop / for next loop, something like that. Counter variable going up to 10, sure. But I never figured out how to set variables for the previous two numbers, or to do the calculation mathematically. So, they got part of my logic behind it, but not a correct answer.
After that were a couple of query questions that should have been easy, but weren’t. After those were a bunch of definition questions, some of which I farted my way through (“What is normalization and when would you go for it?”) and some of which I skipped (“What is a transaction?”). All in all, I answered probably half the questions on the quiz, and got some of those mostly correct. Some of them I knew how to answer in the context of Access, but not SQL (“How do you define a one-to-one, one-to-many, and many-to-many relationship between tables?”).
After the test, my potential supe came in and told me that the test is mainly to see where I stand programming-wise and what my problem-solving thought process is like. He stressed that in entry-level positions, they don’t have much to look at with regards to a body of work, so the test serves to give them an idea of where each applicant stands.
The Powers That Be will be convening by week’s end to decide who gets the job. I’ll keep you all updated.
P.S. – I wore my traditional Halloween dangly bat earrings to the interview. No one noticed. At least Jess noticed when I wore them to Eric and Jess’s reception on Saturday. 🙂