Question 1

Which two are true about data movement between a non-CDB and a PDB using Data Pump? (Choose two.)

Accepted Answer

Correct answer: DE

Question 2

Examine this configuration:
 CDB1is a container database.
 PDB1andPDB2are pluggable databases inCDB1. You execute these commands successfully:
Which two are true? (Choose two.)

Accepted Answer

Correct answer: BE

Question 3

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 containthe 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 CREATECATALOG command?

Accepted Answer

Correct answer: D

Question 4

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

Accepted Answer

Correct answer: DEF

Question 5

Which three are true about Optimizer Statistics Advisor? (Choose three.)

Accepted Answer

https://mikedietrichde.com/2017/08/22/oracle-optimizer-statistics-advisor-in-oracle-database-12-2-0-1/ https://www.oracle.com/technetwork/database/bidatawarehousing/twp-bp-for-stats-gather-19c-5324205.pdf

Question 6

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

Accepted Answer

Correct answer: CD

Question 7

Which three are true about RMAN persistent configuration settings, administration, and their effects? (Choose three.)

Accepted Answer

Correct answer: ABF

Question 8

Examine this configuration:
 CDB1is a container database.
 COMMON_USER_PREFIXisC##.
 PDB1is a pluggable database contained inCDB1.
 APP1_ROOTis an application container contained inCDB1.
 APP1_PDB1is an application PDB contained inAPP1_ROOT.
You execute these commands successfully:
Which two are true? (Choose two.)

Accepted Answer

Correct answer: CF

Question 9

Which two are true about Oracle Flashback features? (Choose two.)

Accepted Answer

Correct answer: DE

Question 10

Which two are true about RMAN encryption? (Choose two.)

Accepted Answer

Correct answer: CD