Security · interview question
Which option is the safer default when shipping code around sql injection prevention?
Multiple choiceHardchapter-17-curatedpremiumsecuritysql-injection-prevention
connection.execute(
"SELECT id FROM orders WHERE id = ?",
(order_id,),
)Answer and explanation
Correct answer
B. Choose the simpler shape that keeps the rule obvious, validated, and easy to observe in logs or tests.
Why
The safest default is usually the one that lowers ambiguity and makes errors easier to diagnose.
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?