Which two are true about duplicating pluggable databases (PDBs) with RMAN?

• A.Two or more PDBs can be duplicated with the same rmak duplicate command.
• B.The auxiliary Instance is automatically created with enable_pluggable_database = true.
• C.cdb$root and pdbSseed are automatically duplicated.
• D.All tablespaces belonging to a PDB must be duplicated when duplicating the PDB.
• E.A user with sysdba or sysbkup must be logged in with RMAN to the PDB to duplicate it.

Comment: *

Name: *

Email: *

Verification: *

Choose two. Your SALES_ROOT application container has two application PDBs. The SALES_APP application has a common table, FIN.REVENUE, in the two PDBs. Examine this query and its output: SELECT containers_default, container_map, table_name FROM dba_tables WHERE owner='FIN' ; CONTAINERS_DEFAULT CONTAINER_MAP CONTAINER_MAP_OBJECT TABLE_NAME -------------------------------------------------------------------------------------------------------------------------------NO YES NO REVENUE NO NO YES MAPTABLE Which two are true?

• A.The REVENUE table must be a list-partitioned table.
• B.The REVENUE table partitions are not pruned across the PDBs automatically.
• C.The MAPTABLE table defines a logical partition key on a commonly used column for the REVENUE table.
• D.The CONTAINERS clause cannot be used in queries on the REVENUE table.
• E.The REVENUE table must be a composite-partitioned table.

Comment: *

Name: *

Email: *

Verification: *

Which two are true about flashback features in Oracle Database 19c and later releases? (Choose two.)

• A.Flashback logs are monitored for being older than the retentionperiod defined in DB_FLASHBACK_RETENTION_TARGET and can be deleted by an administrator written event trigger.
• B.Flashback logs areautomatically purged when DB_FLASHBACK_RETENTION_TARGET is set lower than the time they have already been retained.
• C.Flashback logs are monitored and proactively deleted when beyond the retention period defined in DB_FLASHBACK_RETENTION_TARGET before there is space pressure.
• D.Flashback logs are automatically purged whenever the value of
  DB_FLASHBACK_RETENTION_TARGET is changed.
• E.Flashback logs are monitored and proactively deleted when beyond the retention period defined in DB_FLASHBACK_RETENTION_TARGET only after there is space pressure.

Comment: *

Name: *

Email: *

Verification: *

Which three are true about upgrading Oracle Grid Infrastructure? (Choose three.)

• A.A direct upgrade can be performed only from the immediately preceding Oracle Grid Infrastructure version.
• B.The newer version is installed in a separate Oracle Grid Infrastructure home on the same server as the existing version.
• C.An existing Oracle base can be used.
• D.The upgrade process will automatically install all mandatory patches for the current version of Oracle Grid Infrastructure.
• E.Existing Oracle Database instances must be shut down before starting the upgrade.
• F.Only the grid user can perform the upgrade.

Comment: *

Name: *

Email: *

Verification: *

Which three are true about upgrading Oracle Grid Infrastructure?

• A.An existing Oracle base can be used.
• B.Existing Oracle Database instances must be shut down before starting the upgrade.
• C.The upgrade process will automatically install all mandatory patches for the current version of Oracle Grid Infrastructure.
• D.A direct upgrade can be performed only from the immediately preceding Oracle Grid Infrastructure version.
• E.The newer version is installed in a separate Oracle Grid Infrastructure home on the same server as the existing version.
• F.Only the grid user can perform the upgrade.

Comment: *

Name: *

Email: *

Verification: *