ExamTopics Logo
Mail Us[email protected]
Menu
Oracle Discussions
exam questions

Exam 1z0-083 All Questions

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

Exam 1z0-083 topic 1 question 13 discussion

Actual exam question from Oracle's 1z0-083
Question #: 13
Topic #: 1
[All 1z0-083 Questions]

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 Hide Answer
Suggested Answer: C 🗳️
by git17 at May 27, 2020, 7:06 a.m.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
asefa
Highly Voted 3 years, 9 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
2 years, 5 months 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
2 years, 5 months 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, 1 month ago
thats not in the choices isnt it?
upvoted 1 times
...
...
...
...
janw
Highly Voted 3 years, 11 months ago
agree with c must contain 1, 5, 8 must contain 3 and 6 (not both)
upvoted 9 times
Alejandrrro
3 years, 6 months 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 2 weeks, 1 day 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
7 months, 1 week ago
Selected Answer: B
yes , transportable tablespace
upvoted 1 times
mamadu
4 months, 2 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
8 months, 2 weeks 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
10 months, 1 week 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_
11 months, 3 weeks ago
Selected Answer: C
I think C
upvoted 1 times
...
Guhborges
1 year 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
1 year, 9 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
1 year, 8 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 ago
Selected Answer: C
Must C
upvoted 3 times
...
egore0496
2 years, 5 months 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
2 years, 5 months 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, 1 month 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
2 years, 11 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
...
Dhanushbh
3 years ago
C is correct [Doc ID 2013271.1]
upvoted 1 times
...
fukaka
3 years, 1 month ago
B is correct E is wrong: 1 is a must D is wrong: 3 & 6 need either one A & C are wrong: 5 is not a must if using network mode of data pump
upvoted 4 times
...
Jatindra
3 years, 3 months ago
Correct Answer is E
upvoted 1 times
...
Bda
3 years, 3 months ago
I also think that it should be B.
upvoted 1 times
...
Abdou1968
3 years, 9 months ago
B is a correct answer
upvoted 1 times
...
Load full discussion...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago