Oracle OCP 19c 认证1Z0-083考试(第23题)

最新推荐文章于 2024-10-25 16:55:55 发布

原创

最新推荐文章于 2024-10-25 16:55:55 发布 · 840 阅读

标签

#oracle #ocp

收录于

本博客主要探讨了Oracle数据库19c中关于PDB资源限制的问题。在给出的输出中，选项A和B被确认为正确。A选项指出未在计划中指定的PDB将无法执行并行语句，因为其parallel_server_limit默认设为0。B选项正确是因为PDB3的parallel_server_limit未指定，因此默认为100%，可以在没有资源争用的情况下使用所有可用的并行执行进程。其他选项C、D、E和F因各种原因被判定为不正确，如C选项中PDB可以使用超过保证的资源量，D选项中PDB的资源使用并不受16.5%的限制，E选项未能确认只有三个PDB，而F选项中parallel_server_limit是上限而非保证分配。

Examine this output:

Which two are true? (Choose two.)

A. Any PDB not specified in the plan will be unable to execute statements in parallel.
B. PDB3 can use all available parallel execution processes at times.
C. PDB1 is always limited to 40% of the available system resources regardless of demand.
D. Any PDB not specified in the plan will be able to use a maximum of 16.5% of the available system resources.
E. PDB3 is guaranteed to receive at least 20% of the available system resources if there is enough demand.
F. PDB2 is guaranteed at least 25% of the available parallel execution processes if there is enough demand.

A. Correct as then a PDB will get assigned the default directive with parallel_server_limit set to 0