READ Free Dumps For Oracle- 1z0-020
| Question ID 7730 | You set the PARALLEL_AUTOMATIC_TUNING initialization parameter to FALSE. What happens? (Choose two) |
| Option A | Parallel execution buffers are allocated from the large pool. |
| Option B | Parallel execution buffers are allocated from the shared pool. |
| Option C | Only tables with a degree of parallelism specified will be scanned in parallel. |
| Option D | A load balancing algorithm will be used to distribute evenly load across nodes in a multi instance PQ environment. |
| Correct Answer | BC |
| Question ID 7732 | Which two factors can influence the time taken for instance recovery? (Choose two) |
| Option A | Size of the redo log buffer. |
| Option B | Value of FAST_START_TO_TARGET |
| Option C | Size of the system tablespace. |
| Option D | Value of RECOVERY_PARALLELISM |
| Option E | The number of archived redo logs that have to be read |
| Option F | The number of tables stored in the database buffer cache at the moment of failure. |
| Correct Answer | BD |