READ Free Dumps For Oracle- 1z0-020
| Question ID 8225 | You set the PARALLEL_ADAPTIVE_MULTI_USER initialization parameter to TRUE. What happens? |
| Option A | A parallel server environment will allow only one user connection per instance. |
| Option B | The PARALLEL_AUTOMATIC_TUNING initialization parameter is automatically set to TRUE. |
| Option C | The requested degree of parallelism, specified on a table or through a hint, is reduced to match the current load. |
| Option D | The total number of concurrent parallel query slaves will have a hard-coded platform-dependent maximum value. |
| Correct Answer | C |
| Question ID 8226 | Why would you use the PL/SQL procedure DBMS_TTS.TRANSPORT_SET_CHECK? |
| Option A | To verify whether a set of tablespaces is self-contained. |
| Option B | To create and display the table TRANSPORT_SET_VIOLATIONS |
| Option C | To verify the consistency of a set of unplugged tablespaces. |
| Option D | To check whether a set of tablespaces was successfully transported. |
| Correct Answer | A |