The HR_ROOT application container must support the execution of a query on a table shared by application local PDBs PDB1 and PDB2, and remote PDB PDB3.
Which three are true? (Choose three.)

• A.A database link must exist in the remote CDB referring to the local CDB.
• B.PDB3's application root replica must exist in the local CDB.
• C.A proxy PDB must exist in the application root in the local CDB.
• D.A database link must exist in the local CDB root referring to the remote CDB.
• E.A proxy PDB must exist in the application root in the remote CDB.
• F.The HR_ROOT replica must exist in the remote CDB.

Comment: *

Name: *

Email: *

Verification: *

Which two are true about Oracle Optimizer Statistics, their use, and their collection? (Choose two.)

• A.The Statistics Advisor can help recommend the best way to gather statistics.
• B.Index balanced B*Tree height is considered when evaluating the cost of using an index.
• C.Statistics collected using DBMS_STATS always yield the best optimizer result.
• D.The number of table rows is considered when evaluating the cost of accessing a table using an index.
• E.The Statistics Advisor generates actions for all recommendations.

Comment: *

Name: *

Email: *

Verification: *

You issued this command:
RMAN> BACKUP RECOVERY FILES;
Which two are true? (Choose two.)

• A.All Oracle recovery files not in the current FRA that have not been backed up already, are backed up.
• B.All non-Oracle files in the current FRA that have not been backed up already, are backed up.
• C.All Oracle recovery files in the current FRA that have not been backed up already, are backed up.
• D.All Oracle recovery files in the current fast recovery area (FRA) are backed up.
• E.These backups can be written to disk or SBT.

Comment: *

Name: *

Email: *

Verification: *

You are managing this configuration:
* CDB1 is a container database.
* PDB1 and PDB2 are two pluggable databases in CDB1.
* USER1.EMP is a table in PDB1 and USER2.DEPT is a table in PDB2.
CDB1 user SYS executes these commands after connecting successfully to PDB2:

Which two are true? (Choose two.)

• A.The insert on USER2.DEPT fails because of the active transaction in the parent container.
• B.The inserts on USER1.EMP were committed when the session inserted a row into USER2.DEPT.
• C.The inserts on USER1.EMP were rolled back when the session connected to PDB2.
• D.The inserts on USER1.EMP remain uncommitted when the session connected to PDB2.
• E.The inserts on USER1.EMP were committed when the session connected to PDB2.
• F.The insert on USER2.DEPT is uncommitted.
• G.The insert on USER2.DEPT is a recursive autonomous transaction by the child session and is committed.

Comment: *

Name: *

Email: *

Verification: *

Which three are true about Automatic Workload Repository (AWR)? (Choose three.)

• A.The taking of AWR snapshots can be disabled.
• B.Its collection level is determined by the value of the STATISTICS_LEVEL database parameter.
• C.By default, AWR snapshots are taken every 60 minutes.
• D.AWR data is stored in the SYSTEM tablespace.
• E.By default, AWR snapshots are retained for 7 days.

Comment: *

Name: *

Email: *

Verification: *