Quote:
Originally Posted by ChrisV
The company I work for hired a third party company for screening applicants. Theres an aptitude test, basically an IQ test, and then a software engineering test, which was specific knowledge.
This place is all in-house. I originally spoke with the sysadmin. All of his questions where surrounding that stuff. My answer for how to restart a database was brilliantly verbose.
Quote:
Most stuff was fine, but the SQL questions were like "What does SET TRANSACTION ISOLATION LEVEL SERIALIZABLE do?" And ****. I guess its harder to write a quick quiz for decent db design? IDK.
I have zero clue what that means, but I don't SQL Server either.
As for the decent db design part, I think they are taking the approach of creating a bad design and seeing if my queries respond to it. Some of the tables are obviously bad, though it wouldn't surprise me to see some of it in the wild either (I admit to writing things exactly like this when I first started).
The interviewer said something significant: "I can teach anyone SQL, but I can't teach them logic."
Quote:
Thinly veiled brag: got 100% for aptitude test (ldo) and scored higher than anyone else in the company at the software engineering one. Which involved a lot of guessing.
That's something to be proud of.
Why the guessing, was it a bunch of gotcha and trivia? I hate questions like that.