Which three can be done using Oracle Database Configuration Assistant (DBCA) starting from Oracle Database 19c? (Choose three.)

• A.relocating a remote pluggable database in interactive mode
• B.cloning a remote container database in silent mode
• C.relocating a remote pluggable database in silent mode
• D.relocating aremote container database in interactive mode
• E.cloning a remote container database in interactive mode
• F.cloning a remote pluggable database in silent mode
• G.relocating a remote container database in silent mode

Comment: *

Name: *

Email: *

Verification: *

What is the effect of specifying the "ENABLE PLUGGABLE DATABASE" clause in a "CREATE DATABASE" statement?

• A.ItwillcreateaCDBwithrootopenedandseedmounted.
• B.It will create a CDB that must be plugged into an existing CDB.
• C.It will create a multitenant container database (CDB) with only the root opened.
• D.ItwillcreateaCDBwithrootopenedandseedreadonly.
• E.It will create a CDB with root and seed opened and one PDB mounted.

Comment: *

Name: *

Email: *

Verification: *

Which three are true about Automatic Workload Repository (AWR) snapshots?

• A.They are generated if STATISTICS_LEVEL is set to BASIC.
• B.They are generated if STATISTICS_LEVEL is set to TYPICAL.
• C.They are always created manually.
• D.They are generated if STATISTICS_LEVEL is set to ALL.
• E.They can be retained forever.
• F.They are always created automatically.

Comment: *

Name: *

Email: *

Verification: *

Which three are true about Automatic Workload Repository (AWR)? (Choose three.)

• A.By default, AWR snapshots are taken every 60 minutes.
• B.Its collection level is determined by the value of the STATISTICS_LEVEL database parameter.
• C.By default, AWR snapshots are retained for 7 days.
• D.The taking of AWR snapshots can be disabled.
• E.AWR data is stored in the SYSTEM tablespace.

Comment: *

Name: *

Email: *

Verification: *

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

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

Comment: *

Name: *

Email: *

Verification: *