Which three are true about recovery operations done without using Recovery Manager (RMAN)? (Choose three.)

• A.A lost password file can be re-created with SQL*PLUS.
• B.A lost password file can be manually re-created with the orapwd utility.
• C.A lost TEMPFILE must always be re-created manually.
• D.A lost SPFILE can be recovered from memory using SQL*PLUS.
• E.A lost PFILE can be re-created alert.log using SQL*PLUS.
• F.A lost index tablespace can be re-created without performing any recovery.

Comment: *

Name: *

Email: *

Verification: *

Choose the best answer. How do you configure a CDB for local undo mode?

• A.Open the CDB instance in upgrade mode. In CDB$ROOT, execute ALTER DATABASE LOCAL UNDO ON, and then restart the CDB instance.
• B.Open the CDB instance in upgrade mode. In each PDB, execute ALTER DATABASE LOCAL UNDO ON, create an UNDO tablespace, and then restart the CDB instance.
• C.Open the CDB in read-only mode. In CDB$ROOT, execute ALTER DATABASE LOCAL UNDO ON, and then change the CDB to read/write mode.
• D.Open the CDB instance in restricted mode. In CDB$ROOT, execute ALTER DATABASE LOCAL UNDO ON. create an UNDO tablespace in each PDB, and then restart the CDB instance.
• E.Open the CDB instance in restricted mode. In CDB$ROOT, drop the UNDO tablespace. Execute ALTER DATABASE LOCAL UNDO ON in each PDB, and then restart the CDB instance.

Comment: *

Name: *

Email: *

Verification: *

Which three are true about RMAN persistent configuration settings, administration, and their effects? (Choose three.)

• A.A target database's persistent RMAN configuration settings are always stored in the target's control file
• B.Backup older than the recovery window retention policy are always deleted automatically if the backup location has insufficient space.
• C.Backups written to the fast recovery area (FRA) that are oboslete based on the redundancy retention policy can be deleted automatically to free space.
• D.The RMAN SHOW ALL command displays only settings with nondefault values.
• E.A target database's persistent RMAN configuration settings are always synchronized automatically with the RMAN catalog.
• F.The V$RMAN_CONFIGURATION view displays only settings with values that have been modified.
• G.A DBA must specify either a redundancy retention policy or a recovery window retention policy.

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 interactive mode
• B.relocating a remote pluggable database in interactive mode
• C.relocating a remote pluggable database in silent mode
• D.cloning a remote container database in silent mode
• E.relocating aremote container database in interactive mode
• F.relocating a remote container database in silent mode
• G.cloning a remote pluggable database in silent mode

Comment: *

Name: *

Email: *

Verification: *

A container database called CDB1 is OMF-enabled.
PDB_FILE_NAME_CONVERT is not configured in CDB1. PDB1 was unplugged from CDB1 earlier in the week. Examine this command, which will be executed in CDB1:
CREATE PLUGGABLE DATABASE pdb1
USING '/u01/app/oracle/oradata/pdb1.xml'
SOURCE_FILE_NAME_CONVERT =
('/u01/app/oracle/oradata/', '/u02/app/oracle/oradata/');
Which two are true? (Choose two.)

• A./u01/app/oracle/oradata/pdb1.xml does not contain the current locations of data files for PDB1.
• B.DBMS_PDB.CHECK_PLUG_COMPATIBILITY must be run in CDB1 before executing the command.
• C.PDB1 data files already exist in the correct location.
• D.PDB1 must be dropped from CDB1.
• E.PDB_FILE_NAME_CONVERT must be set before executing the command.

Comment: *

Name: *

Email: *

Verification: *