READ Free Dumps For Oracle- 1z0-144
| Question ID 2717 | Which statements correctly describe the features of functions and procedures? (Choose all that apply.) |
| Option A | A. A procedure can contain a return statement without a value. |
| Option B | B. A function can return multiple values using a single return clause, |
| Option C | C. A procedure can be executed as part of a SQL expression or as a PL/SQL statement, |
| Option D | D. A function can contain zero or more parameters that are transferred from the calling environment. |
| Correct Answer | A |
| Question ID 2718 | Examine the following PL/SQL code; |
| Option A | A. The open cursor is missing |
| Option B | B. The fetch clause is missing |
| Option C | C. The exit when condition is missing |
| Option D | D. The EMP_NAME and EMP_JOB variables cannot be used in the for clause ofthe cursor FOR statement. |
| Correct Answer | B |
