READ Free Dumps For Oracle- 1z0-117
Question ID 2558 | Examine the parallel parameters for your instance. |
Option A | A. Statements accessing tables whom dictionary DOP is 2 or more |
Option B | B. Statements accessing tables whose dictionary DOP is DEFAULT |
Option C | C. Statements that are estimated to execute for more than 10 seconds serially |
Option D | D. Statements accessing tables with any setting for Dictionary DOP |
Option E | E. Statements with parallel hints |
Correct Answer | B,E |
Question ID 2559 | A database instance is configured in the shared server mode and it supports multiple applications running on a middle tier. These applications connect to the database by using different services and tracing is enabled for the services. You want to view the detailed tracing setting for particular service. |
Option A | A. DBMS_SERVICE package |
Option B | B. DBMS_MONITOR package |
Option C | C. DBA_ENABLED_TRACES view |
Option D | D. Trcsess and tkprof |
Correct Answer | C |