READ Free Dumps For Oracle- 1z0-146
| Question ID 2761 |
|
| Option A | A. The security policy remains in effect till the end of the current session. |
| Option B | B. The subsequent queries on the ORDERS table produce an ORA-01031: insufficient privileges error. |
| Option C | C. The subsequent queries on the ORDERS table within the current session are not controlled by the security policy. |
| Option D | D. The subsequent queries on the ORDERS table produce an ORA-28112: failed to execute policy function error. |
| Correct Answer | C |
| Question ID 2762 | Identify two methods for immunizing PL/SQL code against SQL injection attacks. (Choose two.) |
| Option A | A. Use bind arguments. |
| Option B | B. Validate all input concatenated to dynamic SQL. |
| Option C | C. Use dynamic SQLs constructed using concatenation of input values. |
| Option D | D. Use subprograms as part of packages instead of stand-alone subprograms. |
| Correct Answer | A,B |