Security · interview question

If you wrote a test around sql injection prevention, what should the test prove first?

Multiple choiceMediumchapter-17-curatedpremiumsecuritysql-injection-prevention

python

connection.execute(
    "SELECT id FROM orders WHERE id = ?",
    (order_id,),
)

Delay clarity until production traffic reveals the edge case and then patch it under pressure.Keep sql injection prevention implicit so the script stays short and hope the next engineer infers the rule.Solve the symptom with comments only and avoid changing the code shape around sql injection prevention.That the rule behaves correctly at the boundary cases the lesson is trying to make explicit.

Answer and explanation

Correct answer

D. That the rule behaves correctly at the boundary cases the lesson is trying to make explicit.

Why

Good tests make the design safer to change because they lock in the meaningful behavior rather than surface-level implementation details.

Test yourself on Security

A free test with instant, explained results. No account needed.

Start free test

All Security questions →

If you wrote a test around sql injection prevention, what should the test prove first?

Correct answer

Why

More Security questions