SQL - Security Basics
You want to select users with age between two values using parameter binding. Which query correctly uses two parameters for this?
You want to select users with age between two values using parameter binding. Which query correctly uses two parameters for this?
hard📝 Application Q15 of 15
Step-by-Step Solution
Solution:
Step 1: Understand correct syntax for BETWEEN with parameters
The BETWEEN clause requires two values separated by AND; placeholders must match this structure.Step 2: Evaluate options
SELECT * FROM users WHERE age BETWEEN ? AND ? uses two ? placeholders correctly separated by AND. SELECT * FROM users WHERE age BETWEEN :min_age, :max_age uses comma instead of AND, which is invalid. SELECT * FROM users WHERE age BETWEEN ? :max_age mixes placeholder and value incorrectly. SELECT * FROM users WHERE age BETWEEN ? AND is incomplete.Final Answer:
SELECT * FROM users WHERE age BETWEEN ? AND ? -> Option BQuick Check:
BETWEEN needs two placeholders separated by AND [OK]
Quick Trick: BETWEEN needs two placeholders separated by AND [OK]
Common Mistakes:
- Using comma instead of AND in BETWEEN
- Mixing named and positional parameters incorrectly
- Leaving placeholders incomplete
Master "Security Basics" in SQL
Want More Practice?
15+ quiz questions · All difficulty levels · Free
Free Signup - Practice All QuestionsMore SQL Quizzes