nerdexam
Oracle

1Z0-083 · Question #62

Examine this output: Which two are true? (Choose two.)

The correct answer is A. Correct as then a PDB will get assigned the default directive with parallel_server_limit set to 0 B. Correct as parallel_server_limit is not specified for PDB3 and it defaults to 100. https://docs.oracle.com/database/121/ADMIN/dbrm.htm#ADMIN14008 "If PARALLEL_SERVER_LIMIT is not specified, then it defaults to 100%." https://docs.oracle.com/database/121/ADMIN/cdb_dbrm.htm#ADMIN13777 "However, any PDB can use more than the guaranteed amount of a resource if…

Manage Resource Allocation

Question

Examine this output:

Which two are true? (Choose two.)

Exhibit

1Z0-083 question #62 exhibit

Options

  • ACorrect as then a PDB will get assigned the default directive with parallel_server_limit set to 0
  • BCorrect as parallel_server_limit is not specified for PDB3 and it defaults to 100
  • CIncorrect. A PDB can use more resources:
  • DIncorrect. Shares is a minimum guaranteed value. But a PDB can use more as explained
  • EIncorrect. Nothing confirms that there are only 3 PDBs attached. There may be others using
  • FIncorrect. parallel_server_limit is an upper limit.

How the community answered

(36 responses)
  • A
    83% (30)
  • C
    3% (1)
  • D
    8% (3)
  • F
    6% (2)

Explanation

https://docs.oracle.com/database/121/ADMIN/dbrm.htm#ADMIN14008 "If PARALLEL_SERVER_LIMIT is not specified, then it defaults to 100%." https://docs.oracle.com/database/121/ADMIN/cdb_dbrm.htm#ADMIN13777 "However, any PDB can use more than the guaranteed amount of a resource if there is no resource contention." the default pdb directive. Then the share for PDB2 is not 20%

Topics

#Resource Manager#PDB directives#parallel_server_limit#shares

Community Discussion

No community discussion yet for this question.

Full 1Z0-083 Practice