READ Free Dumps For Oracle- 1z0-146
| Question ID 2825 | In which two situations is the body of a result-cached function executed? (Choose two.) |
| Option A | A. if the memory allocated for the result cache is increased |
| Option B | B. if a session on this database instance invokes the function with the same parameter values |
| Option C | C. if the first time a session on this database instance invokes the function with a parameter value |
| Option D | D. if a session executes a data manipulation language (DML) statement on a table or view that was specified in the RELIES_ON clause of a result-cached function |
| Correct Answer | C,D |
| Question ID 2826 | Identify the component of the PL/SQL hierarchical profiler that uploads the result of profiling into database tables. |
| Option A | A. the trace file component |
| Option B | B. the analyzer component |
| Option C | C. the shared library component |
| Option D | D. the data collection component |
| Correct Answer | B |