当前位置 博文首页 > itsaka的博客:Oracle OCP 19c 认证1Z0-083考试(第13题) - 全网

    itsaka的博客:Oracle OCP 19c 认证1Z0-083考试(第13题) - 全网

    作者:[db:作者] 时间:2021-06-14 15:32

    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?
    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

    ?

    You only need to convert the data once. On the source side, you convert the Tablespaces, but on the target side, you convert the datafiles. So answer C is correct.
    Reference: https://docs.oracle.com/en/database/oracle/oracle-database/18/spmdu/converting-data-using-rman.html#GUID-DDFA71A3-396A-440A-B9AB-E0970F843904

    we must convert either on destination or source so A is incorrect (no option 3 and 6)
    we must copy data pump set from source to destination so B is incorrect (no step 5)
    no need to convert on destination if we aleady did conversion on source so D is incorrect (both step 3 and 6) are included
    we must make tablespace read only son E is incorrect
    so answer must be C

    ?