READ Free Dumps For Oracle- 1z0-146
| Question ID 2759 |
|
| Option A | A. It executes successfully and displays 101 and 200000 values. |
| Option B | B. The ASSIGN_VAL function generates an error during compilation because nested tables cannot be returned by functions. |
| Option C | C. The SELECT statement generates an error because the nested table has not been initialized in the ASSIGN VAL function. |
| Option D | D. The ASSIGN_VAL function generates an error during compilation because the EXTEND method cannot be used with nested tables. |
| Correct Answer | C |
| Question ID 2760 | Which two statements are true about the SQL Query Result Cache? (Choose two.) |
| Option A | A. It can store the query results for temporary tables. |
| Option B | B. It can be set at the system, session, or query level. |
| Option C | C. It is used only across statements in the same session. |
| Option D | D. Cached query results become invalid when the data accessed by the query is modified. |
| Correct Answer | B,D |