Oracle
1Z0-117 · Question #126
1Z0-117 Question #126: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-117 to reveal the answer and full explanation for question #126. The question stem and answer options stay visible for context.
Question
Examine the parallelism parameter for your instance: parallel_servers_target Now examine the resource plan containing parallel statement directives: Consumer Group resource plan containing parallel statement directives: Which two are true about parallel statement queuing when this plan is active?
Exhibits
Options
- AUrgent_group sessions collectively can consume up to 64 parallel execution servers before queuing
- BETL_GROUP sessions can collectively consume up to 64 parallel execution servers before the queuing
- CA single OTHER_GROUPS session will execute serially once it is queued for six minutes.
- DA single ETL_GROUP session can consume up to eight parallel execution servers.
- EA single ETL_GROUP session can consume up to 32 parallel execution servers.
- FA single OTHER_GROUPS session will execute in parallel once it is queued for six minutes.
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.