System Design · interview question
You are reviewing a codebase and spot a potential security issue. Which practice is most effective for mitigating SQL injection vulnerabilities?
Multiple choiceEasychapter-20-curatedpremiumsystem-designdefending-tradeoffs
Answer and explanation
Correct answer
C. Using prepared statements with parameterized queries.
Why
Prepared statements with parameterized queries prevent SQL injection by separating SQL logic from data, ensuring that user inputs are treated as data, not executable code.
Test yourself on System Design
A free test with instant, explained results. No account needed.
More System Design questions
- If an interviewer says inventory accuracy is critical during checkout, which design statement is strongest?
- Which approach is the strongest way to start a senior system-design answer?
- When discussing SQL databases, what does ACID stand for, and why is it important?
- During a code review, you spot a potential race condition. What is one effective way to address this in Java?
- In a system design interview, you're asked about CAP theorem. Which two properties can a distributed database…
- In a live coding interview, why is it beneficial to explain your approach aloud while coding?