Choose two.

Vendor: Oracle
Product: 1z0-083
Update on: Jul 27, 2025
Questions: 286

Oracle 1z0-083 Question Answer

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

Executing DBMS_STATS.GATHER_DATABASE_STATS while connected to CDB$ROOT gathers object statistics only in PDB$SEED.

Executing DBMS_STATS.GATHER_DATABASE_STATS while connected to CDB$ROOT gathers object statistics only in CDB$ROOT.

Executing DBMS_STATS.GATHER_DATABASE_STATS while connected to CDB$ROOT gathers object statistics in all open pluggable databases (PDBs).

System statistics can be gathered only while the CDB is in MOUNT state.

Executing DBMS_STATS.GATHER_DATABASE_STATS while connected to a PDB opened in read/ write mode gathers object statistics for that PDB.

Oracle 1z0-083 Summary

Price: $52.5 ~~$149.99~~