Multiple choice technology security

Stored procedure if used for authentication helps against which attack?

  1. Session Hijacking

  2. Session Fixation

  3. Cross Site Scripting

  4. SQL injection

Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

Stored procedures parameterize queries, separating input data from the SQL command structure. This prevents untrusted user authentication payloads from executing arbitrary SQL commands, effectively mitigating SQL injection attacks, whereas it does not directly address session fixation or hijacking.