Oracle

1Z0-146 · Question #64

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

The correct answer is A. Using parameterized queries with bind arguments. D. Validate user inputs to functions that use dynamic SQLs built with concatenated values. See the full explanation below for the reasoning.

Question

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

Options

AUsing parameterized queries with bind arguments.
BUse subprograms that are run with the definer's right.
CUse RESTRICT_REFERENCE clauses in functions that use dynamic SQLs.
DValidate user inputs to functions that use dynamic SQLs built with concatenated values.

How the community answered

(31 responses)

A
71% (22)
B
10% (3)
C
19% (6)

Community Discussion

No community discussion yet for this question.

Sign up to join the discussion

Full 1Z0-146 Practice