Which of the following vulnerabilities does the code snippet resolve?

A developer implement the following code snippet.

Which of the following vulnerabilities does the code snippet resolve?
A . SQL inject
B . Buffer overflow
C . Missing session limit
D . Information leakage

View Answer

Answer: A

Explanation:

SQL injection is a type of vulnerability that allows an attacker to execute malicious SQL commands on a database by inserting them into an input field. The code snippet resolves this vulnerability by using parameterized queries, which prevent the input from being interpreted as part of the SQL command.

Verified Reference:

https://www.comptia.org/training/books/casp-cas-004-study-guide, https://owasp.org/www-community/attacks/SQL_Injection