READ Free Dumps For Oracle- 1z0-146
Question ID 20564 | Which two statements are true about associative arrays and varrays? (Choose two.) |
Option A | Only varrays must use sequential numbers as subscripts |
Option B | Only varrays can be used as column types in database tables |
Option C | Both assocaitive arrays and varrays must use sequential numbers as subscripts |
Option D | Both assocative arrays and varrays can be used as column types in database tables |
Correct Answer | A,B |
Question ID 20565 | Which two statements are true about the SQL Query Result Cache? (Choose two.) |
Option A | It can store the query results for temporary tables |
Option B | It can be set at the system, session or query level |
Option C | It is used only across statements in the same session |
Option D | Cached query results become invalid when the data accessed by the query is modified |
Correct Answer | B,D |