READ Free Dumps For Oracle- 1z0-146
| Question ID 2821 | You execute the following command in the user session: SQL> ALTER SESSION SET PLSQL_DEBUG=true; Which statement is true about the effect of the command? |
| Option A | A. All PL/SQL blocks that are executed subsequently in the session are traced. |
| Option B | B. It enables all PL/SQL blocks that are compiled subsequently in the session for tracing. |
| Option C | C. Only anonymous PL/SQL blocks that are executed subsequently in the session are traced. |
| Option D | D. It enables only named PL/SQL blocks that are executed subsequently in the session for tracing. |
| Correct Answer | B |
| Question ID 2822 | Identify two strategies against SQL injection. (Choose two.) |
| Option A | A. Using parameterized queries with bind arguments. |
| Option B | B. Use subprograms that are run with the definer's right. |
| Option C | C. Use RESTRICT_REFERENCE clauses in functions that use dynamic SQLs. |
| Option D | D. Validate user inputs to functions that use dynamic SQLs built with concatenated values. |
| Correct Answer | A,D |