READ Free Dumps For Oracle- 1z0-020
| Question ID 8199 | 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 | B,C |
| Question ID 8200 | Which parameter would you use to set up archiving to a remote machine? |
| Option A | LOG_ARCHIVE_DEST |
| Option B | LOG_ARCHIVE_DEST_2 |
| Option C | LOG_ARCHIVE_REMOTE_DEST |
| Option D | ARCHIVE_REMOTE_DEST |
| Correct Answer | A |