You have configured RMAN SBT channels to write backups to media.
You then take an RMAN backup by using this command:

Which three are true? (Choose three.)

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

Comment: *

Name: *

Email: *

Verification: *

Examine this configuration: 1. CDB1 is an Oracle Database 12c Release 2 database containing pluggable databases PDB$SEED, PDB1, and PDB2. 2. PDB$SEED is open READ ONLY 3. PDB1 is open READ WRITE 4. PDB2 is MOUNTED. 5. ORACLE_HOME is /u01/app/oracle/product/18.1.0/dbhome_1. You execute these commands before upgrading the database to the current release: For which databases will fixup scripts be created?

• A.PDB$SEED, PDB1, and PDB2 only
• B.CDB1, PDB$SEED, PDB1, and PDB2
• C.CDB1, PDB$SEED, and PDB1 only
• D.CDB1, PDB1, and PDB2 only
• E.CDB1 and PDB$SEED only

Comment: *

Name: *

Email: *

Verification: *

Which three can be done using Oracle Database Configuration Assistant (DBCA) starting from Oracle Database 19c? (Choose three.)

• A.cloning a remote container database in silent mode
• B.cloning a remote container database in interactive mode
• C.relocating a remote container database in interactive mode
• D.relocating a remote container database in silent mode
• E.relocating a remote pluggable database in silent mode
• F.cloning a remote pluggable database in silent mode
• G.relocating a remote pluggable database in interactive mode

Comment: *

Name: *

Email: *

Verification: *

Choose the best answer. Examine this output of an export from the current release of an Oracle multitenant database: $ sqlplus system/oracle . SQL> col name for a10 SQL> select name, open_mode from v$pdbs; NAME OPEN_MODE ---------------------------------------PDB$SEED READ ONLY PDB1 READ WRITE PDB2 MOUNTED SQL> exit Next you execute: $ expdp system/oracle full=y What is the outcome?

• A.It creates a full export of the root
• B.It creates a full export of the root
• C.It creates a full export of only the used while connected to the root container and PDB1. container and all PDBs. container and all open PDBs. root container.
• D.It fails because Data Pump cannot be container.

Comment: *

Name: *

Email: *

Verification: *

Which three are true about the SQL Tuning Advisor? (Choose three.)

• A.It checks each query being analyzed for stale statistics.
• B.It checks each query being analyzed for missing statistics.
• C.It only recommends syntactic changes to SQL statements.
• D.It can recommend semantic changes to SQL statements.
• E.It considers all SQL statements being analyzed by the advisor task as a group.
• F.It builds SQL profiles for each poorly performing SQL statement to prevent regressions.

Comment: *

Name: *

Email: *

Verification: *