Which three are true about using Database Resource Manager in an Oracle multitenant environment?
(Choose three.)

• A.A CDB-level resource plan can limit PDB CPU utilization.
• B.PDB-level resource plans can limit uncommitted UNDO per consumer group.
• C.A PDB-level resource plan can limit session PGA memory.
• D.A CDB-level resource plan can limit session CPU utilization.
• E.A CDB-level resource plan can limit PDB UNDO use.
• F.A CDB-level resource plan is mandatory when using PDB-level resource plans.

Comment: *

Name: *

Email: *

Verification: *

Which two statements are true about recovering logically corrupted tables or table partitions from an RMAN backup?

• A.Tables with not null constraints cannot be recovered.
• B.Tables or table partitions with a foreign key cannot be recovered.
• C.Tables or table partitions can be recovered only when the database is in mount state.
• D.Tables or table partitions from the system and sysaux tablespaces cannot be recovered.
• E.Tables or table partitions can be recovered by using an auxiliary instance only.

Comment: *

Name: *

Email: *

Verification: *

Which three are true about an application seed pluggable database (PDB)?

• A.It is not required in an application container.
• B.A new application PDB created by cloning an application seed PDB can have an up-to-date version of the application installed after cloning completes.
• C.It cannot be dropped from its application container.
• D.It is automatically synchronized with its application root PDB when an application is installed.
• E.It Is automatically synchronized with its application root PDB when an application is upgraded.
• F.A new application PDB created by cloning an application seed PDB can have an old version of the application installed after cloning completes.
• G.It cannot be added to an application container after the application container has already been created.

Comment: *

Name: *

Email: *

Verification: *

Choose two. Your database is in ARCHIVELOG mode and you plan to use Flashback Database. Which two features or parameters manage space availability in the fast recovery area?

• A.the archived log deletion policy
• B.the backup optimization policy
• C.the backup retention policy
• D.the DB_CREATE_ONLINE_LOG_DEST_n parameter setting
• E.the DB_RECOVERY_FILE_DEST parameter setting
• F.using guaranteed UNDO retention

Comment: *

Name: *

Email: *

Verification: *

The users tablespace consists of data files 3 and 4 and must always be online in read/write mode. Which two are true about using RMAN to perform an open database back up of this tablespace?

• A.Backups can be taken only if the database is in archivelog mode.
• B.Backups can be done incrementally.
• C.The database must be registered in an RMAN catalog.
• D.Backups must be done incrementally.
• E.Only consistent backups can be created.
• F.Backups must be contained in backup sets.

Comment: *

Name: *

Email: *

Verification: *