READ Free Dumps For Oracle- 1z0-144
Question ID 2702 | Identify the scenario in which you would use the current of clause for an update or delete statement to rows fetched from a cursor. |
Option A | A. when you want to lock the rows fetched by the cursor |
Option B | B. when you want to update or delete the result set without affecting the rows in the table |
Option C | C. when you want the database not to wait if the requested rows are locked by another user |
Option D | D. when you want to ensure that the current rows fetched by the cursor are updated or deleted |
Correct Answer | B |
Question ID 2703 | Examine the following code: |
Option A | A. The procedure is created successfully and displays the values 20 and 30 when it is called. |
Option B | B. The procedure gives errors because the parameters should be in out mode. |
Option C | C. The procedure gives errors because the host variables cannot be referenced anywhere in the definition of a PL/SQL stored procedure. |
Option D | D. The procedure is created successfully but does not display any values when it is called because the host variables cannot be displayed inside the procedure. |
Correct Answer | A |