Exam 1z0-083 All Questions

View all questions & answers for the 1z0-083 exam

Exam 1z0-083 topic 1 question 13 discussion

Actual exam question from Oracle's 1z0-083

Question #: 13
Topic #: 1

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

Show Suggested Answer

Suggested Answer: C 🗳️

by git17 at May 27, 2020, 7:06 a.m.

Comments

Submit Cancel

asefa

Highly Voted 4 years, 3 months ago

easy way 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

upvoted 15 times

egore0496

3 years ago

Why not B According https://docs.oracle.com/en/database/oracle/oracle-database/19/admin/transporting-data.html#GUID-E4C56852-73A5-44A2-BB10-938831DA6E4C C but what about network mode of data pump or nfs/cifs export?

upvoted 2 times

egore0496

3 years ago

15.2.4 Transporting a Database Over the Network https://docs.oracle.com/en/database/oracle/oracle-database/19/admin/transporting-data.html#GUID-032C9715-B2F8-4ACD-8A1C-C1A899DEA3C1

upvoted 2 times

asduta

2 years, 8 months ago

thats not in the choices isnt it?

upvoted 1 times

...

janw

Highly Voted 4 years, 5 months ago

agree with c must contain 1, 5, 8 must contain 3 and 6 (not both)

upvoted 9 times

Alejandrrro

4 years ago

Agree with C too MOS Doc ID 371556.1 describes the action plan almost the same as in C. Files are converted on the source system

upvoted 2 times

...

alrech

Most Recent 6 months, 4 weeks ago

Selected Answer: C

The correct order is 3, 1, 2, 5, 4, 6, 7, 8. Reference: https://mylearn.oracle.com/ou/ekit/86212/38560/dc9de5cb-8c91-4bd5-bc30-18406127a61b/course Page: 296

upvoted 1 times

...

jaimegarcia

1 year, 1 month ago

Selected Answer: B

yes , transportable tablespace

upvoted 1 times

mamadu

10 months, 3 weeks ago

Answer is C at first i also thought it was B but step 5 is important otherwise you have not moved the exported dump in step 2. then you can choose an option with either of 6 or 3.

upvoted 1 times

...

LEOC71

1 year, 2 months ago

Selected Answer: C

Step 2 is part of all alternatives, then the data pump set created must be transferred to the destination system (step 5). => C: TRUE B:FALSE => to be true step 2 shouldn't be mentioned as part of the procedure, only step 7 (using impdp network mode).

upvoted 1 times

...

flaviogcmelo

1 year, 4 months ago

Selected Answer: C

In my opinion, choosing alternative C instead of B is the detail of making the dump file available to the destination database. https://docs.oracle.com/en/database/oracle/oracle-database/19/spmds/migrating-oracle-database.html#GUID-F224185E-6AEC-45FC-B4F3-7F8B6469606D

upvoted 1 times

...

_gio_

1 year, 6 months ago

Selected Answer: C

I think C

upvoted 1 times

...

Guhborges

1 year, 6 months ago

Selected Answer: C

For me, the right answer should B, but here, we have a lot of person saying the correct one is C, so go with the others.

upvoted 1 times

...

Marcello86CT

2 years, 3 months ago

I would say that correct Answer is : E With Data Pump Conventional Export and Import we no need to make any convesrion because it support different endian format. In conventional mode is not requeired neither to set db in read only.

upvoted 1 times

abdelouahab

2 years, 2 months ago

Hi, the conversion is a must between different endianess see https://docs.oracle.com/en/database/oracle/oracle-database/19/spmdu/task-4-transport-the-tablespace-set.html#GUID-41D10DCA-7733-4E4C-A41A-B94F63A82F7C

upvoted 1 times

...

Patrick9230

2 years, 6 months ago

Selected Answer: C

Must C

upvoted 3 times

...

egore0496

3 years ago

B 5 is not must https://docs.oracle.com/en/database/oracle/oracle-database/19/sutil/oracle-data-pump-export-utility.html#GUID-72973E3D-FC0A-47E8-A62A-6DF8AD83138D Network Considerations for Oracle Data Pump Export

upvoted 2 times

egore0496

3 years ago

15.2.4 Transporting a Database Over the Network https://docs.oracle.com/en/database/oracle/oracle-database/19/admin/transporting-data.html#GUID-032C9715-B2F8-4ACD-8A1C-C1A899DEA3C1

upvoted 1 times

...

asduta

2 years, 8 months ago

5 is a must since above choices doesn't list other type of moving the dump file, including one you mentioned.

upvoted 1 times

...

Neil107

3 years, 5 months ago

It's C. It is always preferred/recommended to convert at the source, as far as possible, rather than convert it at the destination. Saves a lot of headache!

upvoted 1 times

...