READ Free Dumps For Oracle- 1z0-020
Question ID 7758 | 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 7759 | 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 | ONS 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 |