RMAN is connected to a target database instance and an auxilary instance. You execute 3625the command: RMAN> DUPLICATE TARGET DATABASE TO dupdb FROM ACTIVE DATABASE SECTION SIZE 1G; What is the outcome?

• A.RMAN uses the pull method to restore files using image copies
• B.RMAN uses the push method to transfer backup sets
• C.RMAN uses the push method to transfer image copies
• D.RMAN uses the pull method to restore files using backup sets

Comment: *

Name: *

Email: *

Verification: *

You have configured RMAN SBT channels to write backups to medi
a. You then take an RMAN backup by using this command: Which three are true? (Choose three.)

• A.The control file is included in the self-contained archival backup.
• B.The SPFILE is included in the self-contaied archival backup.
• C.The data file backups in the self-contained archive backup are not considered obsolete for two years regardless of the retention policy.
• D.The restore point is a label for the system change number (SCN) before the archival backup was taken.
• E.All archive logs created after this backup are kept for two years.
• F.The restore point is a label for the system change number (SCN) that will be saved two years after the archival backup was taken.

Comment: *

Name: *

Email: *

Verification: *

Your SALES_ROOT application container has two application PDBs.
The SALES_APP application has a common table, FIN.REVENUE, in the two PDBs.
Examine this query and its output:

Which two are true? (Choose two.)

• A.The REVENUE table must be a list-partitioned table.
• B.The MAPTABLE table is a metadata-linked table.
• C.The REVENUE table partitions are not pruned across the PDBs automatically.
• D.A container map exists for the REVENUE table, but is not enabled.
• E.The CONTAINERS clause cannot be used in queries on the REVENUE table.
• F.The MAPTABLE tables defines a logical partition key on a commonly used column for the REVENUE table.

Comment: *

Name: *

Email: *

Verification: *

Which three are true about an application seed pluggable database (PDB)?

• A.It cannot be added to an application container after the application container has already been created.
• B.A new application PDB created by cloning an application seed PDB can have an up-to-date version of the application installed after cloning completes.
• C.It is automatically synchronized with its application root PDB when an application is installed.
• D.It cannot be dropped from its application container.
• E.It Is automatically synchronized with its application root PDB when an application is upgraded.
• F.It is not required in an application container.
• G.A new application PDB created by cloning an application seed PDB can have an old version of the application installed after cloning completes.

Comment: *

Name: *

Email: *

Verification: *

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

• A.Executing DBMS_STATS.GATHER_DATABASE_STATS while connected to CDB$ROOT gathers object statistics only in PDB$SEED.
• B.Executing DBMS_STATS.GATHER_DATABASE_STATS while connected to CDB$ROOT gathers object statistics only in CDB$ROOT.
• C.Executing DBMS_STATS.GATHER_DATABASE_STATS while connected to CDB$ROOT gathers object statistics in all open pluggable databases (PDBs).
• D.Executing DBMS_STATS.GATHER_DATABASE_STATS while connected to a PDB opened in read/ write mode gathers object statistics for that PDB.
• E.System statistics can be gathered only while the CDB is in MOUNT state.

Comment: *

Name: *

Email: *

Verification: *