Oracle Database Administration II 1z0-083 Question # 55 Topic 6 Discussion

Oracle Database Administration II 1z0-083 Question # 55 Topic 6 Discussion

1z0-083 Exam Topic 6 Question 55 Discussion:
Question #: 55
Topic #: 6

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


A.

Executing DBMS_STATS.GATHER_DATABASE_STATS while connected to CDB$ROOT gathers object statistics in all open PDBs except PDB$SEED.


B.

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


C.

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


D.

System statistics can be gathered only while connected to CDB$ROOT.


E.

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


Get Premium 1z0-083 Questions

Contribute your Thoughts:


Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.