Choose the best answer. You want to transport the UNIVERSITY tablespace from one database to another. The UNIVERSITY tablespace is currently open read/write. The source and destination platforms have the same endian Examine this list of steps:. 1. Make the UNIVERSITY tablespace read-only on the source 2. Export the UNIVERSITY tablespace metadata using EXPDP. 3. Create a cross-platform backup set from the UNIVERSITY source system, using an RMAN command that includes the DATAPUMP clause. 4. Copy the cross-platform backup sets to the destination system. 5. Copy the Data Pump dump set from the source to the destination system. 6. Restore the cross-platform backup set on the destination system using an RMAN command that includes the DATAPUMP clause. 7. Import the UNIVERSITY tablespace metadata using IMPDP. 8. Make the UNIVERSITY tablespace read/write on the destination system. Which are the minimum number of steps required, in the correct order, to transport the UNIVERSITY tablespace?

• A.1,2,3,4,5,6,7,8
• B.1,3,4,6,8
• C.2,3,4,5,6,7
• D.3,4,6

Comment: *

Name: *

Email: *

Verification: *

Choose three. Which three are true about Oracle pluggable databases (PDBs)?

• A.A PDB can be plugged into a CDB only if both are of the same Oracle Database release.
• B.A PDB in a remote CDB can be accessed transparently thereby aggregating results from local and remote PDBs.
• C.A PDB unplugged from a container database (CDB) can be plugged into a different CDB without altering any of its schemas.
• D.An unplugged PDB can be plugged into multiple CDBs simultaneously by sharing data files.
• E.A PDB created from PDB$SEED must be set to READ WRITE after loading data.
• F.A PDB created from PDB$SEED must be set to READ ONLY after loading data.
• G.A non-CDB can be converted into a PDB.

Comment: *

Name: *

Email: *

Verification: *

Which three are true about Database Point-in-Time Recovery? (Choose three.)

• A.The target point for the recovery must bespecified as a stime or System Change Number (SCN).
• B.Thedatabase must be in MOUNT state when performing Database Point-in-Time Recovery.
• C.The database must be open RESETLOGS after Database Point-in-Time Recovery.
• D.The database must have FLASHBACK DATABASE ON to perform Database Point-in-Time Recovery.
• E.The Database must be in ARCHIVELOG mode.
• F.Database Point-in-Time Recovery is performed by the Managed Recovery Process (MRP)

Comment: *

Name: *

Email: *

Verification: *

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

• A.It is only possible for RMAN to connect to a pluggable database as a target if an RMAN Virtual Private Catalog is used.
• B.It is always possible for RMAN to connect to a pluggable database as a target if any RMAN Catalog is used.
• C.A Virtual Private Catalog used to register a container database must be created in a pluggable database.
• D.A Virtual Private Catalog used to register a container database can be created in a pluggable database.
• E.It is always possible for RMAN to connect to a pluggable database as a target.
• F.A Virtual Private Catalog used to register a container database can be created in a non-container database.

Comment: *

Name: *

Email: *

Verification: *

Which two are facets of performance planning that should always be considered or implemented for an Oracle Database environment? (Choose two.)

• A.defining foreign keys for all tables to speed up joins
• B.using check constraints to speed up updates
• C.defining primary keys for all tables to speed up all queries
• D.the physical data model
• E.the configuration of storage arrays

Comment: *

Name: *

Email: *

Verification: *