READ Free Dumps For Oracle- 1z0-146
| Question ID 2775 | Identify three guidelines for the DBMS_ASSERT package. (Choose three.) |
| Option A | A. Prefix all calls to DBMS ASSERT with the SYS schema name. |
| Option B | B. Embed DBMS_ASSERT verification routines inside the injectable string. |
| Option C | C. Escape single quotes when you use the ENQUOTE_LITERAL procedure. |
| Option D | D. Define and raise exceptions explicitly to handle DBMS_ASSERT exceptions. |
| Option E | E. Prefix all calls to DBMS_ASSERT with a schema name that owns the subprogram that uses the DBMS_ASSERT package. |
| Correct Answer | A,C,D |
| Question ID 2776 | Which two statements are true about cursor variables? (Choose two.) |
| Option A | A. A cursor variable points to the current row in the result set of a multirow query stored in a work area. |
| Option B | B. A cursor variable is an explicitly named work area in which the results of different multirow queries can be stored. |
| Option C | C. A cursor variable can be used only if a query is performed and its results are processed in the same subprogram. |
| Option D | D. A cursor variable can be used to perform a query in one subprogram, and process the results in a different subprogram. |
| Correct Answer | A,D |