In SQL, which of the following can act as a placeholder for literal values in a query, which are then injected into the database?

Correct option is E

Bind Variables are placeholders used in SQL queries to hold literal values. They are replaced with actual values during query execution, enhancing query performance by allowing reuse of the query with different parameters. They also protect against SQL injection attacks.
Important Key Points:
1. Bind variables optimize performance by reducing query parsing time.
2. They enhance security by separating the query structure from its data values.
3. They are used in Prepared Statements for dynamic query execution.
Knowledge Booster:
· Categorical, Continuous, and Discrete Variables: Common in data analysis, not SQL-specific.
· Confounding Variables: Found in statistics, unrelated to SQL queries.
· SQL Injection Prevention: Bind variables prevent SQL injection by treating inputs as data rather than code.