Oracle
1Z0-146 · Question #16
1Z0-146 Question #16: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-146 to reveal the answer and full explanation for question #16. The question stem and answer options stay visible for context.
Question
Examine the following line of code that is part of a PL/SQL application: stmt:='SELECT session_id FROM sessions WHERE ' || p_where_stmt; Identify a solution for preventing SQL injection in the above code.
Options
- AReplace P_WHERE_STMT with a bind variable.
- BDo not use APIs that allow arbitrary query parameters to be exposed.
- CUse the RESTRICT_REFERENCES clause in the PL/SQL subprogram that contains the code.
- DUse DBMS_SQL to detect that the expression provided for P_WHERE_STMT is free from SQL injection.
Unlock 1Z0-146 to see the answer
You've previewed enough free 1Z0-146 questions. Unlock 1Z0-146 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.