READ Free Dumps For Oracle- 1z0-146
| Question ID 2865 | View the Exhibit and examine the code in the PL/SQL block. The PL/SQL block generates an error on execution. What is the reason? |
| Option A | A. The DELETE(n) method cannot be used with varrays. |
| Option C | C. The NEXT method cannot be used with an associative array with VARCHAR2 key values. |
| Option D | D. The NEXT method cannot be used with a nested table from which an element has been deleted. |
| Correct Answer | A |
| Question ID 2866 | Which two statements are true about the migration of BasicFile to the SecureFile format by using the DBMS_REDEFINITION package? (Choose two.) |
| Option A | A. It can be performed only on tables with a single LOB column. |
| Option B | B. It automatically creates an interim table during the migration process. |
| Option C | C. It allows the table that is migrated to be accessed throughout the migration process. |
| Option D | D. It requires free space that is at least equal to the space used by the table that is migrated. |
| Option E | E. It requires all constraints defined on the original table to be re-created manually after the migration. |
| Correct Answer | C,D |