OWASP Vulnerabilities · interview question
Why do teams use parameterized queries in production code?
Multiple choiceMediumchapter-17-curatedpremiumowasp-vulnerabilitiessql-injection
Answer and explanation
Correct answer
C. They prevent SQL injection
Why
Parameterized queries, or PreparedStatements, prevent SQL injection by treating input values as data, not executable code. This ensures that malicious input is not executed as part of SQL commands.
Test yourself on OWASP Vulnerabilities
A free test with instant, explained results. No account needed.
More OWASP Vulnerabilities questions
- How would you explain a potential consequence of not using prepared statements in SQL queries in an interview?
- In the context of JWTs, what is the risk of not validating the 'alg' field in the header?
- Why is it important to validate the 'exp' claim in a JWT?
- How does the Spring Security filter chain protect against SQL Injection?
- How would you explain a potential risk of not using CSRF tokens in web applications in an interview?
- What does 'stateless' imply in the context of JWT?