A.The database must be open RESETLOGS after Database Point-in-Time Recovery.

B.The Database must be in ARCHIVELOG mode.

C.The target point for the recovery must be specified as a stime or System Change Number (SCN).

D.The database must be in MOUNT state when performing Database Point-in-Time Recovery.

E.The database must have FLASHBACK DATABASE ON to perform Database Point-in-Time Recovery.

F.Database Point-in-Time Recovery is performed by the Managed Recovery Process (MRP)

A.Control file backups can be created while connected to a nonroot container.

B.Archived Redo Log backups can be created while connected to an application root CDB.

C.The BACKUP TABLESPACE command can back up a PDB tablespace even if RMAN is connected to CDB$ROOT.

D.Online Redo Log backups can be created while connected to the root container.

E.Control file backups can be created while connected to the root container.

A.New templates can only be created by modifying an existing user-created template.

B.The Data Warehouse template is most suitable when transaction response time is the key criterion.

C.Oracle DBCA templates can be used to create new databases and duplicate existing databases.

D.The General Purpose or Transaction Processing templates are most suitable when concurrency and recoverability are key criteria.

E.Oracle DBCA templates can store only logical structure and not database files.

A.Real-Time Query must be enabled on a primary database for automatic block repair to be done on any of its physical standby databases.

B.Real-Time Query must be enabled on a physical standby database for automatic block repair to be done on its primary database.

C.Automatic block repair can repair blocks with no standby database if DB_BLOCK_CHECKING = TRUE.

D.It is not possible for media corrupt blocks.

E.Real-Time Query must be enabled on a physical standby database for automatic block repair to be done on that physical standby database.

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.