Home » Oracle » 1z0-117 » Which two cases will the degree of parallelism be automatically calculated?
Examine the parallel parameters for your instance.
All parallel execution servers are available and the session use default parallelism settings.
In which two cases will the degree of parallelism be automatically calculated?
A. Statements accessing tables whom dictionary DOP is 2 or more
B. Statements accessing tables whose dictionary DOP is DEFAULT
C. Statements that are estimated to execute for more than 10 seconds serially
D. Statements accessing tables with any setting for Dictionary DOP
E. Statements with parallel hints
Correct Answer: BE
Explanation/Reference:
Note:In earlier versions of the Oracle Database, we had to determine the DOP more or less manually, either with a parallel hint or by setting a parallel degree with alter table. There was an automatic computation of the DOP available for the objects with dictionary DOP of default, derived from the simple formula CPU_COUNT * PARALLEL_THREADS_PER_CPU.
Download Printable PDF. VALID exam to help you PASS.
|
|