Security · interview question
A teammate submits shaky sql injection prevention code. Which review comment is the strongest?
Multiple choiceMediumchapter-17-curatedpremiumsecuritysql-injection-prevention
Answer and explanation
Correct answer
B. Make the rule clearer and easier to explain. Bind values separately from SQL text so attackers cannot reshape the query through input.
Why
The best review comment anchors the change to readability, correctness, and future maintenance. Query string interpolation is one of the oldest mistakes because it is easy to write and dangerous to ship.
Test yourself on Security
A free test with instant, explained results. No account needed.
More Security questions
- What is the healthiest performance judgment around secrets management?
- What is the clearest sign that code around secrets management should be refactored?
- Which boundary choice best fits log redaction in a maintainable Python system?
- If input validation fails in production, what handling philosophy is strongest?
- Which response shows the healthiest evidence-first mindset around input validation?
- When is log redaction being used in the wrong way?