READ Free Dumps For Oracle- 1z0-146
| Question ID 2755 | Which two reports can be retrieved by using the various procedures in the DBMS_METADATA PL/SQL package? (Choose two.) |
| Option A | A. DDL report for all objects dependent on a table |
| Option B | B. DDL report for all the objects stored in a tablespace |
| Option C | C. DDL report for all the invalidated objects in a schema |
| Option D | D. data definition language (DDL) report for all the tables in a schema |
| Correct Answer | A,D |
| Question ID 2756 | 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 B | B. The DELETE(n) method cannot be used with nested tables. |
| 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 |
