Oracle
1Z0-117 · Question #74
1Z0-117 Question #74: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-117 to reveal the answer and full explanation for question #74. The question stem and answer options stay visible for context.
Question
Your database supports a workload consisting of three categories of SQL statements: - Statements that should execute in less than one minute - Statement that may execute for up to 15 minutes - Statements that may be executed for more than 15 minutes You set PARALLEL_DEGREE_POLICY to Auto. You plan to prioritize queued statements by using the Database Resource manager. Which two are true about parallelism prioritization by a consumer group?
Options
- APARALLEL_TARGET_PERCENTAGE is used to prioritize a consumer group's use of the overall
- BQueuing is done for a consumer group exceeding its percentage, even if the number of busy PX
- CPARALLEL_TARGET_PERCENTAGE us used to prioritize a consumer group's use of the overall
- DHaving separate queues for consumer groups requires the use of management attributes (MGMT_P1,
- ESeparate queue timeout using PARALLEL_QUEUE_TIMEOUT require the use of management attributes
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.