A.Statistics collected using DBMS_ATATS always yield the best optimizer result.

B.The number of table rows is considered when evaluating the cost of accessing a table using an index.

C.The Statistics Advisor can help recommend the best way to gather statistics.

D.The Statistics Advisor generates actions for all recommendations.

E.Index balanced B*Tree height is considered when evaluating the cost of using an index,

A.Uncommitted transactions in PDB1 have been rolled back.

B.PDB1 is closed.

C.CDB1 is shut down.

D.Uncommitted transactions in CDB1 and PDB1 have been rolled back.

E.CDB1 is in MOUNT state

A.AWR reports can be generated while connected to any container.

B.AWR snapshots can be created in CDB$ROOT.

C.All AWR data is stored in the CDB$ROOT SYSAUX tablespace.

D.No AWR data is stored in the CDB$ROOT SYSAUX tablespace.

E.ADDM can run in a nonroot container.

F.AWR snapshots can be created in a PDB.

A.undo tablespaces

B.redo logs

C.mandatory Oracle-supplied PL/SQL packages

D.all data dictionary metadata

E.temporary tablespaces

F.user-defined PL/SQL packages

G.control files

A.CDB1, PDB1, and PDB2 only

B.CDB1, PDB$SEED, PDB1, and PDB2

C.CDB1 and PDB$SEED only

D.PDB$SEED, PDB1, and PDB2 only

E.CDB1, PDB$SEED, and PDB1 only