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

• A.RMAN encryption keys are stored in a database keystore.
• B.RMAN can encrypt the Oracle Database password file.
• C.Dual-mode encrypted backups can be restored only if both the password and the keystore used for encryption are available.
• D.The SET ENCRYPTIONcommand overrides encryption settings specified by the CONFIGURE ENCRYPTIONcommand.
• E.Password encryption can be persistently configured using the CONFIGURE ENCRYPTIONcommand.

Comment: *

Name: *

Email: *

Verification: *

A container database called CDB1 is OMF-enabled.
PDB_FILE_NAME_CONVERT is not configured in CDB1. PDB1 was unplugged from CDB1 earlier in the week. Examine this command, which will be executed in CDB1:
CREATE PLUGGABLE DATABASE pdb1
USING '/u01/app/oracle/oradata/pdb1.xml'
SOURCE_FILE_NAME_CONVERT =
('/u01/app/oracle/oradata/', '/u02/app/oracle/oradata/');
Which two are true? (Choose two.)

• A.DBMS_PDB.CHECK_PLUG_COMPATIBILITY must be run in CDB1 before executing the command.
• B./u01/app/oracle/oradata/pdb1.xml does not contain the current locations of data files for PDB1.
• C.PDB1 must be dropped from CDB1.
• D.PDB1 data files already exist in the correct location.
• E.PDB_FILE_NAME_CONVERT must be set before executing the command.

Comment: *

Name: *

Email: *

Verification: *

Choose two. Which two are true about PDB archive files?

• A.They contain all the data files only in compressed form for a PDB.
• B.They must be created using the DBMS_PDB package.
• C.They contain a PDB manifest file and all the data files in compressed form for a PDB.
• D.They contain all the data files only in uncompressed form for a PDB.
• E.DBMS_PDB.CHECK_PLUG_COMPATIBILITY can be run against a PDB archive.
• F.They contain a PDB manifest file and all the data files in uncompressed form for a PDB.

Comment: *

Name: *

Email: *

Verification: *

Which two are true about creating pluggable databases (PDBs) using snapshots in Oracle 19c and later releases? (Choose two.)

• A.A snapshot copy PDB can be created from a stand-alone clone PDB.
• B.A PDB snapshot depends on a storage snapshot which can only be stored on specific file systems.
• C.A snapshot copy PDB depends on a storage snapshot which can only be stored on specific file systems.
• D.A PDB snapshot is always a sparse copy of the source PDB.
• E.A PDB snapshot is always a full copy of the source PDB.
• F.A PDB snapshot depends on a storage snapshot which can be stored on any file system.
• G.A snapshot copy PDB depends on a storage snapshot which can be stored on any file system.

Comment: *

Name: *

Email: *

Verification: *

Which two are true about Oracle Flashback features?

• A.flashback drop can undrop an index when undropping a table.
• B.flashback query can retrieve redo records from online and archived redo log files.
• C.After a database is restored from flashback logs using the flashback database command, it is sometimes rolled forward using redo logs.
• D.flashback version query can retrieve redo records from online and archived redo log files.
• E.flashback table can undrop a column.

Comment: *

Name: *

Email: *

Verification: *