Which two are true about memory advisors? (Choose two.)

• A.All memory advisors use data from Automatic Workload Repository.
• B.If Automatic Shared Memory Management is enabled, both the SGA Advisor and PGA Advisor are always available.
• C.If Manual Shared Memory Management is enabled, only the Shared Pool Advisor and Buffer Cache Advisor are available.
• D.If Automatic Memory Management is enabled, no memory advisors are available.
• E.If Automatic Memory Management is enabled, the Shared Pool Advisor and Buffer Cache Advisor are available to set the maximum size for these individual System Global Area components.

Comment: *

Name: *

Email: *

Verification: *

Examine this configuration:
CDB1 is an Oracle Database 12c Release 2 database containing pluggable databases PDB$SEED, PDB1, and PDB2.
PDB$SEED is open READ ONLY
PDB1 is open READ WRITE
PDB2 is MOUNTED.
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.CDB1 and PDB$SEED only
• B.PDB$SEED, PDB1, and PDB2 only
• C.CDB1, PDB$SEED, and PDB1 only
• D.CDB1, PDB$SEED, PDB1, and PDB2
• E.CDB1, PDB1, and PDB2 only

Comment: *

Name: *

Email: *

Verification: *

Your container database, CDB1, has an application container, HR_ROOT, with an application PDB, HR_PDB1. You have the required privilege to clone HR_PDB1 to container database CDB2, which does not contain HR_ROOT. Which two are always true? (Choose two.)

• A.The HR_PDB1clone created in CDB2 will be in mount state when cloning ends.
• B.Cloning HR_ROOT automatically clones HR_PDB1.
• C.CDB1 and CDB2 must be in shared undo mode.
• D.All transactions in HR_PDB1 of CDB1 must commit before the cloning process starts.
• E.A common user must exist in CDB2 with the CREATE PLUGGABLE DATABASE privilege.

Comment: *

Name: *

Email: *

Verification: *

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

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

Comment: *

Name: *

Email: *

Verification: *

Which three are true about using Database Upgrade Assistant (DBUA) to upgrade a database? (Choose three.)

• A.A whole database backup must exist before upgrade
• B.DBUA must be launched from the target Oracle Home.
• C.All pluggable databases are automatically upgraded as part of a container database upgrade.
• D.The Pre-Upgrade Information Tool script is executed by DBUA.
• E.Multiple databases with the same ORACLE_HOME can be upgraded simultaneously.
• F.The database must be opened in read-only mode.

Comment: *

Name: *

Email: *

Verification: *