News
Welcome to the News community!
Rules:
1. Be civil
Attack the argument, not the person. No racism/sexism/bigotry. Good faith argumentation only. This includes accusing another user of being a bot or paid actor. Trolling is uncivil and is grounds for removal and/or a community ban. Do not respond to rule-breaking content; report it and move on.
2. All posts should contain a source (url) that is as reliable and unbiased as possible and must only contain one link.
Obvious biased sources will be removed at the mods’ discretion. Supporting links can be added in comments or posted separately but not to the post body. Sources may be checked for reliability using Wikipedia, MBFC, AdFontes, GroundNews, etc.
3. No bots, spam or self-promotion.
Only approved bots, which follow the guidelines for bots set by the instance, are allowed.
4. Post titles should be the same as the article used as source. Clickbait titles may be removed.
Posts which titles don’t match the source may be removed. If the site changed their headline, we may ask you to update the post title. Clickbait titles use hyperbolic language and do not accurately describe the article content. When necessary, post titles may be edited, clearly marked with [brackets], but may never be used to editorialize or comment on the content.
5. Only recent news is allowed.
Posts must be news from the most recent 30 days.
6. All posts must be news articles.
No opinion pieces, Listicles, editorials, videos, blogs, press releases, or celebrity gossip will be allowed. All posts will be judged on a case-by-case basis. Mods may use discretion to pre-approve videos or press releases from highly credible sources that provide unique, newsworthy content not available or possible in another format.
7. No duplicate posts.
If an article has already been posted, it will be removed. Different articles reporting on the same subject are permitted. If the post that matches your post is very old, we refer you to rule 5.
8. Misinformation is prohibited.
Misinformation / propaganda is strictly prohibited. Any comment or post containing or linking to misinformation will be removed. If you feel that your post has been removed in error, credible sources must be provided.
9. No link shorteners or news aggregators.
All posts must link to original article sources. You may include archival links in the post description. News aggregators such as Yahoo, Google, Hacker News, etc. should be avoided in favor of the original source link. Newswire services such as AP, Reuters, or AFP, are frequently republished and may be shared from other credible sources.
10. Don't copy entire article in your post body
For copyright reasons, you are not allowed to copy an entire article into your post body. This is an instance wide rule, that is strictly enforced in this community.
view the rest of the comments
Literally include "Can you name four basic SQL commands?" any time I interview someone and it's a great litmus test.
I appreciate the use of a good old-fashioned shibboleth like this. Thanks.
I'm a software engineer with 15+ years of experience and this question had me stumped.
Select insert update delete?
Create alter drop rollback?
Or did you mean types of commands? But of those there are 5?
Or is that question supposed to get garbage response?
God it's late.
Nailed it
Although I'm willing to accept "CREATE, DROP, TRUNCATE" in the mix of for no order reason that it shows they know basics.
I'm not following, wouldn't an LLM be able to easily answer that one?
knowing absolutely nothing about this topic, i would assume an actual competent person would be able to answer them immediately and confidently, someone reading an LLM prompt is probably sounds like they're reading from a script even if the answers arent wrong
People aren't always able to regurgitate encyclopedic knowledge in interviews. Sure some can, but many have anxiety about interviews in general, or stuff going on in their lives which can make them not the sharpest when hit with a rando question like this. There are some absolutely brilliant people I've hired that would fail miserably if this was how they were measured.
Some people work better with scenario based questions instead of bulleted memorized answers. Honestly, I'd much rather have a candidate that knows the concept being discussed even if they can't remember the exact name of a term or the name of a flag they'd need to include when issuing a command. Those last things can be googled in the moment. Conceptual knowledge and understanding is much more important to me than wrote memorization.
Well, thats what I experienced from my original post, but I'm not sure it will always be that. Someone more clever could take the answer from the LLM and paraphrase it, or put it in their own words and sound competent.
Not in an in person interview
I was confused as to why no one suggested this yet lol