Identify two strategies against SQL injection. (Choose two.)

Identify two strategies against SQL injection. (Choose two.)

Identify two strategies against SQL injection. (Choose two.)

A.
Using parameterized queries with bind arguments.

B.
Use subprograms that are run with the definer’s right.

C.
Use RESTRICT_REFERENCE clauses in functions that use dynamic SQLs.

D.
Validate user inputs to functions that use dynamic SQLs built with concatenated values.



Leave a Reply 4

Your email address will not be published. Required fields are marked *


manjusha

manjusha

‘B’ is also correct rt? Why it is wrong

Leo Yu

Leo Yu

why c) is incorrect? RESTRICT_REFERENCE can prevent runtime to modify table, packag variable.