Question 151

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 format.
Examine this list of steps:
1. Make the UNIVERSITY tablespace read-only on the source system.
2. Export the UNIVERSITY tablespace metadata using EXPDP.
3. Create a cross-platform backup set from the UNIVERSITY tablespace on the 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?
  • Question 152

    Which three are true about thresholds, metrics, and server-generated alerts? (Choose three.)
  • Question 153

    Which three are true about the tools for diagnosing Oracle Database failure situations? (Choose three.)
  • Question 154

    Which three are true about the FLASHBACK DATABASE feature? (Choose three.)
  • Question 155

    Your sales_root application container has two application PDBs.
    The sales_app application has a common table, FIN.REVENUE, in the two PDBs.
    Examine this query and its output:

    Which two are true?