Which two are true about creating RMAN backups for an Oracle container database?

• A.The backup database plus archivelog command will back up archive logs when RMAN is connected to a PDB.
• B.The backup database command will create a pluggable database (PDB) backup when RMAN is connected to a PDB.
• C.spfile backups can be created while connected to an application root PDB.
• D.The backup pluggable database command can be used to back up cdb$root.
• E.Tablespaces from different PDBs with identical names must be backed up by connecting RMAN separately to each PDB to back up the tablespaces.

Comment: *

Name: *

Email: *

Verification: *

Which two are true about Oracle Database Configuration Assistant (DBCA)? (Choose two.)

• A.It can only be launched from the command line interface.
• B.It can be used to convert a non-container database to a container database.
• C.It can be used to create container databases and non-container databases.
• D.It can be used to change the character set of an existing database.
• E.It can be launched from both the command line and the Universal Installer (OUI) interfaces.

Comment: *

Name: *

Email: *

Verification: *

Choose three. Which three are true about configuring CONTROLFILE AUTOBACKUP by using RMAN?

• A.The server parameter file (SPFILE) is automatically backed up each time the control file is backed up.
• B.The control file is backed up automatically each time the SPFILE is backed up manually.
• C.The control file is backed up whenever a new tablespace is created.
• D.It requires the use of fast recovery area (FRA).
• E.The control file is backed up whenever an RMAN backup is successfully recorded in the catalog.
• F.The control file is backed up whenever a new table is created.

Comment: *

Name: *

Email: *

Verification: *

Which four are true about performing Tablespace Point -In-Time Recovery (TSPITR) using Recovery Manager (RMAN)?

• A.It can be performed repeatedly until the correct time is found without using an RMAN catalog.
• B.RMAN always includes tablespaces containing undo segments in the recovery set.
• C.It can be performed using an auxiliary instance managed by RMAN.
• D.It can be used to recover a truncated table.
• E.RMAN automatically adds any required tablespaces to the recovery set to make it self-contained.
• F.It can be performed using anauxiliary instance managed by a DBA.
• G.It can be used to recover a dropped tablespace.
• H.flashback database must be enabled for it to work.

Comment: *

Name: *

Email: *

Verification: *

You are managing this configuration:
1. CDB1 is a container database.
2. BDB1 and PDB2 are two pluggable databases in CDB1.
3. user1 .EMP Is a table In PDBI and user2.DEPT is a table in PDB2.

Which two are true?

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

Comment: *

Name: *

Email: *

Verification: *