Oracle Exam 1Z0-083 Topic 8 Question 109 Discussion

Actual exam question for Oracle's 1Z0-083 exam

Question #: 109
Topic #: 8

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

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

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

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

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

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

Show Suggested Answer

Suggested Answer: A, D

by Herman at Dec 05, 2024, 12:57 PM

Limited Time Offer

25%

Off

Contribute your Thoughts:

Submit Cancel

2 days ago

Option B is correct. Gathering statistics while connected to a PDB gathers statistics for that PDB only.

upvoted 0 times

...

21 days ago

I'm not sure, but I think B) and D) are the correct options.

upvoted 0 times

...

23 days ago

I agree with Xenia, A) and E) make sense.

upvoted 0 times

...

28 days ago

I think A) and E) are true.

upvoted 0 times

...