1z0-083 Exam Questions and Answers | Exam-Dumps.net (Page: 9)

Which two are true about changing the LOCAL_UNDO_ENABLED property to false in a CDB? (Choose two.)

After the change, only a common user with the required privilege can create an undo tablespace in CDB&ROOT.
Any new PDB and existing PDBs are automatically configured to use the default undo tablespace in CDB$ROOT.
After the change, only one undo tablespace can exist in CDB$ROOT.
After the change, any user with the required privilege can create an undo tablespace in the PDBs.
Undo tablespaces existing in PDBs must be dropped before the change.
After the change, each existing PDB has to be reopened for the new undo mode to take effect.

Answer(s): A,B

Which two are true about SQL Performance Analyzer (SPA)? (Choose two.)

It is integrated with the SQL Access Advisor.
It predicts the impact of system changes on SQL workload response time.
It provides before and after execution statistics for each SQL statement in the analysis task
It offers fine-grained analysis of all the SQL statements in the analysis task as a group.
SQL statements that were originally run concurrently are run concurrently by SPA.

Answer(s): B,C

Which two are true about gathering optimizer statistics? (Choose two.)

Executing DBMS_STATS.GATHER_DATABASE_STATS while connected to CDB$ROOT gathers object statistics in all open PDBs except PDB$SEED.
Executing DBMS_STATS.GATHER_DATABASE_STATS while connected to a PDB opened in read/ write mode gathers object statistics for that PD
Executing DBMS_STATS.GATHER_DATABASE_STATS while connected to CDB$ROOT gathers object statistics only in CDB$ROOT.
System statistics can be gathered only while connected to CDB$ROOT.
Executing DBMS_STATS.GATHER_DATABASE_STATS while connected to CDB$ROOT gathers object statistics in all open pluggable databases (PDBs)

Answer(s): B,C

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

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

Answer(s): F

Which two statements are true about Resource Manager plans for individual pluggable databases (PDB plans) in a multitenant container database (CDB)?

If no PDB plan is enabled for a pluggable database, then all sessions for that PDB are treated to an equal degree of the resource share of that PDB.
In a PDB plan, subplans may be used with up to eight consumer groups.
If a PDB plan is enabled for a pluggable database, then resources are allocated to consumer groups across all PDBs in the CDB.
If no PDB plan is enabled for a pluggable database, then the PDB share in the CDB plan is dynamically calculated.
If a PDB plan is enabled for a pluggable database, then resources are allocated to consumer groups based on the shares provided to the PDB in the CDB plan and the shares provided to the consumer groups in the PDB plan.

Answer(s): A,E

Oracle 1z0-083 Exam (page: 9) Oracle Database Administration II Updated on: 01-Sep-2025