Which three are true about Automatic Workload Repository (AWR) and Automatic Database Diagnostic Monitor (ADDM) in an Oracle multitenant environment? (Choose three.)

• A.AWR snapshots can be created in a PDB.
• B.AWR snapshots can be created in CDB$ROOT.
• C.All AWR data is stored in the CDB$ROOT SYSAUX tablespace.
• D.ADDM can run in a nonroot container.
• E.AWR reports can be generated while connected to any container.
• F.No AWR data is stored in the CDB$ROOT SYSAUX tablespace.

Comment: *

Name: *

Email: *

Verification: *

Which two are true about RMAN encryption? (Choose two.)

• A.RMAN encryption keys are stored in a database keystore.
• B.RMAN can encrypt the Oracle Database password file.
• C.Dual-mode encrypted backups can be restored only if both the password and the keystore used for encryption are available.
• D.The SET ENCRYPTION command overrides encryption settings specified by the CONFIGURE ENCRYPTION command.
• E.Password encryption can be persistently configured using the CONFIGURE ENCRYPTION command.

Comment: *

Name: *

Email: *

Verification: *

When backing up to the Oracle Fast Recovery Area (FRA), you determine that the backup takes too long and suspect a performance bottleneck.
Which two are true about diagnosing and tuning these problems?

• A.Data files with a high value in v$backup_sync_io.discrete_bytes_per_second are a potential performance bottleneck when synchronous I/O is used.
• B.If an rman backup validate command takes roughly the same time as an actual backup, then both read and write I/O are likely bottlenecks.
• C.If an rman backup validate command takes noticeably less time than an actual backup, then write I/O is a likely bottleneck.
• D.Data files with a high value in v$backup_async_io.short_waits are a potential performance bottleneck when asynchronous I/O is used.
• E.If an rman backup validate command takes roughly the same time as an actual backup, then read I/O is a likely bottleneck.

Comment: *

Name: *

Email: *

Verification: *

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

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

Comment: *

Name: *

Email: *

Verification: *

Examine these queries and their output:

After a system crash, an instance restart and an attempted opening of the PDBs result in:

Which two are true? (Choose two.)

• A.Data file 24 can be recovered while CDB$ROOT and PDB$SEED are opened.
• B.Data file 24 must be recovered while the CDB is opened.
• C.Data file 24 must be recovered while PDB2 is closed.
  19c: PDB SYSTEM or UNDO Tablespace Recovery: The CDB and all other PDBs can be left opened. 1. Connect to PDB 2. Shutdown abort the PDB, if its not automatically done. sqlplus sys@sales_pdb as sysdba sql> SHUTDOWN ABORT; OR ALTER PLUGGABLE DATABASE CLOSE ABORT; rman target sys@slaes_pdb rman> restore database; rman> recover database; rman> alter pluggable database sales_pdb open;
• D.Data file 24 can be recovered while PDB2 is opened.
• E.Data file 24 cannot be recovered while the CDB is opened.

Comment: *

Name: *

Email: *

Verification: *