nerdexam
Zend

200-530 · Question #89

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

(34 responses)
  • A
    3% (1)
  • B
    3% (1)
  • C
    85% (29)
  • D
    9% (3)

Community Discussion

No community discussion yet for this question.

Full 200-530 Practice