Oracle
1Z0-117 · Question #125
1Z0-117 Question #125: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-117 to reveal the answer and full explanation for question #125. The question stem and answer options stay visible for context.
Question
Examine the following anonymous PL/SQL code block of code: Which two are true concerning the use of this code?
Exhibit
Options
- AThe user executing the anonymous PL/SQL code must have the CREATE JOB system privilege.
- BALTER SESSION ENABLE PARALLEL DML must be executed in the session prior to executing the
- CAll chunks are committed together once all tasks updating all chunks are finished.
- DThe user executing the anonymous PL/SQL code requires execute privilege on the DBMS_JOB package.
- EThe user executing the anonymous PL/SQL code requires privilege on the DBMS_SCHEDULER package.
- FEach chunk will be committed independently as soon as the task updating that chunk is finished.
Unlock 1Z0-117 to see the answer
You've previewed enough free 1Z0-117 questions. Unlock 1Z0-117 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.