READ Free Dumps For Oracle- 1z0-146
| Question ID 2849 | Which guidelines should be considered when designing and using cursors in a PL/SQL block? ? (Choose all that apply.) |
| Option A | A. When fetching from a cursor, fetch into a record. |
| Option B | B. Use parameters with cursors so that the result set for the cursor is not tied to a specific variable in a program. |
| Option C | C. Use the %NOTFOUND attribute in combination with the SELECT INTO statement to check for non existent values. |
| Option D | D. Whenever possible, explicitly declare the cursor and use the OPEN, FETCH and CLOSE statements to manipulate the cursor instead of using cursor FOR loop. |
| Option E | E. When using data manipulation language statements, (DML) reference a SQL cursor attribute immediately after the DML statement executes in the same block. |
| Correct Answer | A,B,E |
| Question ID 2850 | View the Exhibit and examine the settings for the PLSQL_CODE_TYPE parameter.
|
| Option A | A. The procedure would be invalidated. |
| Option B | B. The procedure would remain as NATIVE code type. |
| Option C | C. The procedure would be changed to INTERPRETED code type. |
| Option D | D. The command would produce an error and the procedure must be compiled using the PLSQL_CODE_TYPE attribute with value INTERPRETED. |
| Correct Answer | C |
