Which two are true about RMAN backups when using a media manager to write backups to tape when there are only two tape drives?

• A.The SBT device should be configured to use parallelism 2 to allow both tape drives to be used simultaneously
• B.SBT tape compression and RMAN backup compression should be used in parallel.
• C.Any backup written to the SBT device in this configuration can contain a maximum of two backup sets.
• D.SBT tape compression can be used even if no RMAN compression is configured.
• E.Any backup set written to the SBT device in this configuration can contain a maximum of two backup pieces.

Comment: *

Name: *

Email: *

Verification: *

Examine these actions:
1. Create a new database for a recovery catalog.
2. Create a tablespace with sufficient space in the catalog database for the recovery catalog.
3. Configure archivelog mode for the catalog database.
4. Create a user to own the recovery catalog schema with quota on the tablespace that will contain the catalog.
5. Grant the recovery_catalog_owner role to the recovery catalog schema owner.
6. Grant the sysbackup privilege to the recovery catalog schema owner.
Which are the minimum actions that must be performed before executing the create catalog command?

• A.2, 4, 5, 6
• B.2, 4, 5
• C.1,2,3,4, 5,6
• D.1,2,4, 5
• E.1,3,4, 5

Comment: *

Name: *

Email: *

Verification: *

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

• A.Executing DBMS_STATS.GATHER_DATABASE_STATS while connected to CDB$ROOT gathers object statistics in all open PDBs except PDB$SEED.
• 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 connected to CDB$ROOT.
• E.Executing DBMS_STATS.GATHER_DATABASE_STATS while connected to CDB$ROOT gathers object statistics in all open pluggable databases (PDBs)

Comment: *

Name: *

Email: *

Verification: *

Which two are true about RMAN backups when using a media manager to write backups to tape when there are only two tape drives? (Choose two.)

• A.Any backup written to the SBT device in this configuration can contain a maximum of two backup sets.
• B.SBT tape compression and RMAN backup compression should be used in parallel.
• C.Any backup set written to the SBT device in this configuration can contain a maximum of two backup pieces.
• D.The SBT device should be configured to use PARALLELISM 2 to allow both tape drive to be used simultaneously.
• E.SBT tape compression can be used even if no RMAN compression is configured.

Comment: *

Name: *

Email: *

Verification: *

Which two are prerequisites for performing Flashback Transaction?

• A.A supplemental log must be enabled for the primary key.
• B.Fast Recovery Area must be enabled for the database
• C.Undo retention guarantee must be configured for the database.
• D.The EXECUTE privilege must be granted to a user on the DBMS_FLASHBACK package.
• E.A supplemental log must be enabled for the primary key.

Comment: *

Name: *

Email: *

Verification: *