READ Free Dumps For Oracle- 1z0-146
| Question ID 2833 | View Exhibit1 and examine the structure of the EMPLOYEES table. View Exhibit2 and examine the code in the PL/SQL block. The PL/SQL block fails to execute. What could be the reason? |
| Option A | A. Nested tables cannot be returned by a function. |
| Option B | B. The NEWNAMES nested table has not been initialized. |
| Option C | C. The assignment operator cannot be used to transfer all the element values from GROUP1 to GROUP2. |
| Option D | D. The third element of OLDNAMES cannot be assigned to the third element of GROUP1 because they are of inconsistent data types. |
| Option E | E. LAST_NAME values cannot be assigned to the V_LAST_NAMES nested table because local collection types are not allowed in SQL statements. |
| Correct Answer | E |
| Question ID 2834 | Which two statements are true about the usage of the |
| Option A | A. You can describe remote objects. |
| Option B | B. You can describe anonymous PL/SQL blocks. |
| Option C | C. You can describe a stored procedure, stored function, packaged procedure, or packaged function. |
| Option D | D. You can obtain information about the position, name, and data type of the arguments of a procedure. |
| Correct Answer | C,D |