[Solved] Given the prepared statement:PREPARE stmt FROM 'SELECT name FROM users WHERE age > ?'; EXECUTE stmt USING @age;If @age = 30, what will the query return? | SQL

SQL - Security Basics

Given the prepared statement:

PREPARE stmt FROM 'SELECT name FROM users WHERE age > ?';
EXECUTE stmt USING @age;

If @age = 30, what will the query return?

AAll user names regardless of age

BAll user names where age equals 30

CAll user names where age is greater than 30

DAn error because @age is not defined

Step-by-Step Solution

Solution:

Step 1: Understand the prepared statement query
The query selects names from users where age is greater than a parameter.
Step 2: Substitute the parameter value
With @age = 30, the query returns users with age > 30.
Final Answer:
All user names where age is greater than 30 -> Option C
Quick Check:
Output = A [OK]

Quick Trick: Parameter replaces ? in prepared statements [OK]

Common Mistakes:

Master "Security Basics" in SQL

9 interactive learning modes - each teaches the same concept differently

More SQL Quizzes

Given the prepared statement: