Which three are true about Recovery Manager (RMAN) in Oracle Database 19c and later releases? (Choose three.)

• A.A Virtual Private Catalog used to register a container database can be created in a pluggable database.
• B.A Virtual Private Catalog used to register a container database can be created in a non-container database.
• C.A Virtual Private Catalog used to register a container database must be created in a pluggable database.
• D.It is always possible for RMAN to connect to a pluggable database as a target if any RMAN Catalog is used.
• E.It is always possible for RMAN to connect to a pluggable database as a target.
• F.It is only possible for RMAN to connect to a pluggable database as a target if an RMAN Virtual Private Catalog is used.

Comment: *

Name: *

Email: *

Verification: *

Which three methods can be used for heap table data migration after upgrading a database?

• A.using Database Upgrade Assistant
• B.using operating system file copy utilities
• C.using Database Replay
• D.using the create table AS select SQL statement
• E.using Oracle Data Pump
• F.using SQL Developer

Comment: *

Name: *

Email: *

Verification: *

Automatic Shared Memory Management is disabled for one of your database instances.
Some SQL statements perform poorly due to excessive hard parse activity, thereby degrading performance.
What would be your next step?

• A.Run the Memory Advisor for the Program Global Area.
• B.Run the SQL Tuning Advisor.
• C.Run the SQL Access Advisor.
• D.Run the Memory Advisor for the shared pool.
• E.Run the Memory Advisor for the System Global Area.

Comment: *

Name: *

Email: *

Verification: *

Choose three. Which three are true about SGA memory management in a multitenant database?

• A.The SGA_TARGET setting for a PDB cannot exceed 50% of the SGA_TARGET value of the root container.
• B.Setting DB_CACHE_SIZE for a PDB guarantees a minimum amount of Database Buffer Cache memory for that PDB.
• C.Setting SHARED_POOL_SIZE for a PDB guarantees a minimum amount of Shared Pool memory for that PDB.
• D.The SHARED_POOL_SIZE setting for a PDB can be up to 80% of the SHARED_POOL_SIZE setting of the root container.
• E.SGA_MIN_SIZE cannot be set for a PDB.
• F.Setting SGA_TARGET for a PDB guarantees a minimum amount of SGA memory for that PDB.

Comment: *

Name: *

Email: *

Verification: *

Choose two. Which two are true about gathering optimizer statistics?

• A.Executing DBMS_STATS.GATHER_DATABASE_STATS while connected to CDB$ROOT gathers object statistics in all open pluggable databases (PDBs).
• B.Executing DBMS_STATS.GATHER_DATABASE_STATS while connected to a PDB opened in read/ write mode gathers object statistics for that PDB.
• C.Executing DBMS_STATS.GATHER_DATABASE_STATS while connected to CDB$ROOT gathers object statistics only in CDB$ROOT.
• D.System statistics can be gathered only while the CDB is in MOUNT state.
• E.Executing DBMS_STATS.GATHER_DATABASE_STATS while connected to CDB$ROOT gathers object statistics only in PDB$SEED.

Comment: *

Name: *

Email: *

Verification: *