Oracle Database Administration II — Question 15

You must transport the UNIVERSITY tablespace from one database to another.
The UNIVERSITY tablespace is currently open read/write.
The source and destination platforms have different endian formats.
Examine this list of actions:
1. Make the UNIVERSITY tablespace read-only on the source system.
2. Export the UNIVERSITY tablespace metadata using EXPDP.
3. Convert the UNIVERSITY tablespace data files to the destination platform format using RMAN on the source system.
4. Copy the UNIVERSITY tablespace data files to the destination system.
5. Copy the Data Pump dump set to the destination system.
6. Convert the UNIVERSITY tablespace data files to the destination platform format using RMAN on the destination system.
7. Import the UNIVERSITY tablespace metadata using IMPDP.
8. Make the UNIVERSITY tablespace read/write on the destination system.
Which is the minimum number of actions required, in the correct order, to transport the UNIVERSITY tablespace?

Answer options

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

Correct answer: C

Explanation

The correct answer is C because it includes all necessary steps to ensure that the UNIVERSITY tablespace is properly prepared and transferred, including making it read-only, exporting metadata, converting data files, copying them, and finally importing the metadata. Options A, B, D, and E do not include the required actions for handling the endian format or the necessary steps to ensure the integrity of the tablespace during transport.