easyMultiple ChoiceObjective-mapped
CISSP Practice Question: During a code review, a developer identifies a…
During a code review, a developer identifies a SQL injection vulnerability. What is the most effective fix?
Answer choices
Why each option matters
Answer the question above first, then reveal the full breakdown to understand why each option is right or wrong.
Correct answer & explanation
✓
Implement parameterized queries.
Parameterized queries (prepared statements) ensure user input is treated as data, not executable code. Stored procedures can still be vulnerable if dynamically built. Escaping input is error-prone. ORMs often use SQL underneath and may not prevent injection if misused.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
Use stored procedures exclusively.
Why it's wrong here
Stored procedures can still be vulnerable if they use dynamic SQL with concatenated input. They are not the most effective fix.
- ✗
Use an ORM framework.
Why it's wrong here
ORMs typically use parameterized queries internally, but developers can bypass them with raw SQL. They are not the most reliable prevention.
- ✗
Escape all input.
Why it's wrong here
Escaping input is error-prone and often insufficient; it's better to use parameterized queries.
- ✓
Implement parameterized queries.
Why this is correct
Parameterized queries (prepared statements) ensure user input is treated as data, not executable code, making them the most effective fix.
Go deeper
Related to this question
About these practice questions
One of 747 original CISSP practice questions on Courseiva, each with a full explanation and wrong-answer analysis — not exam dumps or protected exam content. Learn why practice questions differ from exam dumps →
JA
Written by Johnson Ajibi, MSc IT Security
Senior Network & Security Engineer · founder of Courseiva
This CISSP practice question is part of Courseiva's free ISC2 certification practice question bank. Courseiva provides original exam-style practice questions with explanations, topic-based practice, mock exams, readiness tracking, and study analytics to help learners prepare for the CISSP exam.