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

Get Premium 1Z0-083 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Stephanie

1 months ago

Hmm, I wonder if the exam will ask us to gather stats on the cafeteria menu next. Gotta keep those optimizer stats up-to-date, y'know?

upvoted 0 times

Elza

16 days ago

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

upvoted 0 times

...

Xuan

1 months ago

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

upvoted 0 times

...

Pearly

2 months ago

Wait, so we can't gather system statistics unless we're in CDB$ROOT? That's a bummer. I was hoping to do that from a PDB.

upvoted 0 times

Vicente

1 months ago

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

upvoted 0 times

...

Dana

1 months ago

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

upvoted 0 times

...

Toi

2 months ago

I think option E is also correct. Executing DBMS_STATS.GATHER_DATABASE_STATS while connected to CDB$ROOT should gather statistics for all open PDBs.

upvoted 0 times

...

Joanna

2 months ago

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

upvoted 0 times

...

Rodolfo

2 months ago

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

upvoted 0 times

...

Rosio

2 months ago

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

upvoted 0 times

...

Xenia

3 months ago

I think A) and E) are true.

upvoted 0 times

...