Which four are true about RMAN backup sets? (Choose four.)

• A.Blocks from multiple data files can be contained in one backup piece,
• B.Blocks from multiple data files can be contained in one backup set,
• C.A backup set must be written to disk.
• D.A backup set must be written to media.
• E.A backup piece can belong to only one backup set.
• F.A backup set can contain only one backup piece.
• G.A data file can be split into multiple sections stored in different backup sets.
• H.A data file can be split into multiple sections stored in different backup pieces in the same backup set.

Comment: *

Name: *

Email: *

Verification: *

Choose three. Which are three of the steps taken by Database Configuration Assistant (DBCA) to clone a remote pluggable database (PDB) starting from Oracle 19c?

• A.automatically dropping the database link to the remote database if it already exists
• B.creating a database link from CDB$ROOT in the local database to CDB$ROOT in the remote system that is to be cloned
• C.creating a database link from CDB$ROOT in the remote database to be cloned to CDB$ROOT in the local database
• D.creating a new empty PDB in the local database from PDB$SEED
• E.creating a database link from CDB$ROOT in the local database to the PDB in the remote system that is to be cloned
• F.opening the cloned PDB
• G.creating a database link from CDB$ROOT in the remote database to the PDB in the local database

Comment: *

Name: *

Email: *

Verification: *

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

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

Comment: *

Name: *

Email: *

Verification: *

Which four are true about performing Tablespace Point-In-Time Recovery (TSPITR) using Recovery Manager (RMAN)?

• A.It can be used to recover a dropped tablespace.
• B.RMAN always includes tablespaces containing undo segments in the recovery set.
• C.It can be performed using an auxiliary instance managed by a DBA.
• D.It can be performed using an auxiliary instance managed by RMAN.
• E.It can be used to recover a truncated table.
• F.flashback database must be enabled for it to work.
• G.It can be performed repeatedly until the correct time is found without using an RMAN catalog.
• H.RMAN automatically adds any required tablespaces to the recovery set to make it self-contained.

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

Comment: *

Name: *

Email: *

Verification: *