READ Free Dumps For Oracle- 1z0-117
| Question ID 2532 | A database supports three applications: CRM, ERP, and ACC. These applications connect to the database by using three different services: CRM_SRV for the CRM application, ERP_SRV for the ERP application, and ACC_SRV for the ACC application. |
| Option A | A. All trace information for the service connection to inst1 will be stored in a single trace file. |
| Option B | B. A trace file is not created because the module name is not specified. |
| Option C | C. A single trace file is created for each session that uses the ACC_SRV service. |
| Option D | D. Only those SQL statements that are identified with the ACC_SRV service executed on the inst1 instance are recorded in trace files. |
| Option E | E. All trace information for the ACC_SRV service connected to inst1 is stored in multiple trace files, which can be consolidated by using the tkprof utility. |
| Correct Answer | C |
| Question ID 2533 | Examine the following anonymous PL/SQL code block of code: |
| Option A | A. The user executing the anonymous PL/SQL code must have the CREATE JOB system privilege. |
| Option B | B. ALTER SESSION ENABLE PARALLEL DML must be executed in the session prior to executing the anonymous PL/SQL code. |
| Option C | C. All chunks are committed together once all tasks updating all chunks are finished. |
| Option D | D. The user executing the anonymous PL/SQL code requires execute privilege on the DBMS_JOB package. |
| Option E | E. The user executing the anonymous PL/SQL code requires privilege on the DBMS_SCHEDULER package. |
| Option F | F. Each chunk will be committed independently as soon as the task updating that chunk is finished. |
| Correct Answer | A,E |
