FizzBuzz 2.0: Pragmatic Programming Questions For Software Engineers

https://ift.tt/2PhMCrk

A former YC partner co-founded a recruiting company for technical hiring, and one of its software engineers is long-time Slashdot reader compumike. He now writes:
Like the decade-old Fizz Buzz Test, there are some questions that are trivial for anyone who can build software at a professional level, but are likely to stump anyone who can’t hack it. I analyzed the data from over 100,000 programmers to reveal how five multiple-choice questions easily separate the real software engineers from the rest. The questions (and the data about correct answers) come from Triplebyte’s own coder-recruiting quiz, and "98% of successful engineers answer at least 4 of 5 correctly," explains Mike’s article. ("Successful" engineers are defined as those who went on to receive an inbound message from a company matching their preferences through Triplebyte’s platform.) "I’m confident that if you’re an engineering manager running an interview, you wouldn’t give an offer to someone who performed below that line." Question 1: What kind of SQL statement retrieves data from a table?
LOOKUPREADFETCHSELECT