READ Free Dumps For Oracle- 1z0-144
| Question ID 2704 | Examine the following PL/SQL code: |
| Option A | A. It displays null if no employee with employee_id 123 exists. |
| Option B | B. It produces the ora-01403: no data found error if no employee with employee_id 123 exists. |
| Option C | C. It displays an error because the select into clause cannot be used to populate the PL/SQL record type. |
| Option D | D. The code executes successfully even if no employee with employee_id 123 exists and displays Record Not Found. |
| Correct Answer | B |
| Question ID 2705 | Which statement is true about transactions in PL/SQL? |
| Option A | A. A transaction can span multiple blocks. |
| Option B | B. A block can contain only a single transaction. |
| Option C | C. SERVERPOINTS cannot be created in a PL/SQLblock. |
| Option D | D. The END keyword signals the end of a PL/SQL block and automatically commits the transaction in the block. |
| Correct Answer | A |