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

Free Oracle 1z0-083 Exam Questions (page: 12)