READ Free Dumps For Oracle- 1z0-146
| Question ID 20626 | See the Exhibit:
Nested tables cannot be returned by a function The PL/SQL block fails to execute; |
| Option A | Nested tables cannot be returned by a function |
| Option B | The NEWNAMES nested table has not been initialized |
| Option C | The assignment operator cannot be used to transfer all the element values from GROUP1 to GROUP2 |
| Option D | The third element of OLDNAMES cannot be assigned to the thrid element of GROUP1 because they |
| Option E | LAST_NAME values cannot be assigned to the V_LAST_NAMES nested table because local collection |
| Correct Answer | E |
| Question ID 20627 | Which two statements are true about the query results stored in the qeury result cache? (Choose two.) |
| Option A | If any of the tables used to build a query is modified by an ongoing transaction in the current session |
| Option B | A query result based on a read-consistent snapshot of data that is older than the latest committed |
| Option C | Adding the RESULT_CACHE hint to inline views enables optimizations between the outer query and |
| Option D | A query result for a query that has a bind variable is stored in the cache and is reused if the query is |
| Correct Answer | A,B |