National_Instruments
200-500 · Question #74
Which is the most secure approach for handling dynamic data in SQL queries?
The correct answer is C. Use prepared statements if supported by the database library, data-specific escaping functions. See the full explanation below for the reasoning.
Question
Which is the most secure approach for handling dynamic data in SQL queries?
Options
- AUse addslashes().
- BEnable magic_quotes_gpc.
- CUse prepared statements if supported by the database library, data-specific escaping functions
- DUse stored procedures.
How the community answered
(47 responses)- A17% (8)
- B6% (3)
- C72% (34)
- D4% (2)
Community Discussion
No community discussion yet for this question.