Exam 1z0-083 topic 1 question 179 discussion

Actual exam question from Oracle's 1z0-083

Question #: 179
Topic #: 1

A container database, CDB1, contains a pluggable database PDB1.

Another container database is called CDB2.

You want to relocate PDB1 from CDB1 to CDB2 with near-zero down time.

Which three are required? (Choose three.)

A. CDB2 must be in archivelog mode.
B. CDB1 and CDB2 must both be in local UNDO mode.
C. CDB2 must be in shared UNDO mode only.
D. CDB1 must be in shared UNDO mode only.
E. CDB1 must be in archivelog mode.
F. CDB1 and CDB2 must be in shared UNDO mode.

Show Suggested Answer

Suggested Answer: ABE 🗳️

by ilputto at Jan. 15, 2023, 4:23 p.m.

Comments

Submit Cancel

antonica

9 months ago

Target CDB in Shared Mode: The target CDB doesn't need to be in Local Undo mode. In that case the new PDB being relocated will be converted to "Shared Undo". But you could have an issue here, if your source PDB is receiving several DMLs you could have some issues when you try to open the new PDB in read-write you will get a message saying "unrecovered txns found". In that case you must clear those unrecovered transactions by yourself and then re-execute "alter pluggable database open".

upvoted 1 times

...

_gio_

1 year, 5 months ago

Selected Answer: ABE

just because the others are surely wrong

upvoted 1 times

...

ScottL

1 year, 8 months ago

A,B,E correct

upvoted 1 times

...

jeylightyear1

1 year, 11 months ago

https://oracle-base.com/articles/12c/multitenant-relocate-pdb-12cr2 source and target CDBs need to have local undo mode so C,D,F is false Agree with A,B,E

upvoted 2 times

...

ilputto

1 year, 11 months ago

Selected Answer: ABE

abe in my opinion

upvoted 4 times

...