READ Free Dumps For Oracle- 1z0-050
| Question ID 5963 | Which statements are true regarding the Query Result Cache? (Choose all that apply.) |
| Option A | It can be set at the system, session, or table level. |
| Option C | It is used only across statements in the same session. |
| Option D | It can store the results from normal as well as flashback queries. |
| Option E | It can store the results of queries based on normal, temporary, and dictionary tables. |
| Correct Answer | A,C |
| Question ID 5964 | You want to analyze a SQL Tuning Set (STS) using SQL Performance Analyzer in a test database. Which two statements are true regarding the activities performed during the test execution of SQLs in a SQL Tuning Set? (Choose two.) |
| Option A | Every SQL statement in the STS is considered only once for execution. |
| Option B | The SQL statements in the STS are executed concurrently to produce the execution plan and execution statistics. |
| Option C | The execution plan and execution statistics are computed for each SQL statement in the STS. |
| Option D | The effects of DDL and DML are considered to produce the execution plan and execution statistics. |
| Correct Answer | A,C |