ISC2 Certified Secure Software Lifecycle Professional (CSSLP) Practice Question
During a black-box penetration test of a RESTful web service, you discover that its search endpoint passes the cat query-string parameter directly to an outdated data-access library recently reported vulnerable to SQL injection. Which single test request would most convincingly prove the flaw is exploitable in the running environment?
Inject a time-based blind payload like ' OR IF(1=1,SLEEP(5),0)-- and watch for a noticeable response delay.
Review the application's JavaScript files to see if the cat parameter is validated on the client side.
Add a single apostrophe (') to the cat parameter and observe whether the server returns an SQL syntax error.
Append a UNION SELECT payload such as union select null,'pwned',null-- to the cat parameter and look for the string pwned in the response.
Appending a tailored UNION SELECT clause that returns a known string (for example union select null,'pwned',null--) shows both that the injected SQL runs and that arbitrary result sets can be merged into the application's response. A lone apostrophe may trigger an error, and a time-delay payload may confirm code execution, but neither demonstrates data extraction. Reviewing client-side scripts or brute-forcing passwords does not test for SQL injection at all.
Ask Bash
Bash is our AI bot, trained to help you pass your exam. AI Generated Content may display inaccurate information, always double-check anything important.
What is SQL injection in a black-box penetration test?
Open an interactive chat with Bash
Why is UNION SELECT effective for proving SQL injection?
Open an interactive chat with Bash
How does confirming data extraction differ from detecting syntax errors?
Open an interactive chat with Bash
ISC2 Certified Secure Software Lifecycle Professional (CSSLP)
Secure Software Testing
Your Score:
Report Issue
Bash, the Crucial Exams Chat Bot
AI Bot
Loading...
Loading...
Loading...
Pass with Confidence.
IT & Cybersecurity Package
You have hit the limits of our free tier, become a Premium Member today for unlimited access.
Military, Healthcare worker, Gov. employee or Teacher? See if you qualify for a Community Discount.
Monthly
$19.99
$19.99/mo
Billed monthly, Cancel any time.
3 Month Pass
$44.99
$14.99/mo
One time purchase of $44.99, Does not auto-renew.
MOST POPULAR
Annual Pass
$119.99
$9.99/mo
One time purchase of $119.99, Does not auto-renew.
BEST DEAL
Lifetime Pass
$189.99
One time purchase, Good for life.
What You Get
All IT & Cybersecurity Package plans include the following perks and exams .