200-901 Application Deployment and Security Practice Question
A web application is vulnerable to SQL injection. Which secure coding practice should the developer implement in the code to prevent this?
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
✓
Use parameterised queries for database access.
Using parameterised queries (prepared statements) ensures that user input is treated as data, not executable SQL code, preventing SQL injection.
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 parameterised queries for database access.
Why this is correct
Parameterised queries separate SQL logic from data, preventing injection.
- ✗
Escape all user input with htmlspecialchars.
Why it's wrong here
Escaping is for XSS prevention, not SQL injection.
- ✗
Use a CAPTCHA on the login form.
Why it's wrong here
CAPTCHA prevents automated attacks but not SQL injection.
Go deeper
Related to this question
About these practice questions
One of 989 original 200-901 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 200-901 practice question is part of Courseiva's free Cisco 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 200-901 exam.