Exam 1z0-083 All Questions

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

Exam 1z0-083 topic 1 question 58 discussion

Actual exam question from Oracle's 1z0-083

Question #: 58
Topic #: 1

Your container database, CDB1, has an application container, HR_ROOT, with an application PDB, HR_PDB1.
You have the required privilege to clone HR_PDB1 to container database CDB2, which does not contain HR_ROOT.
Which two are always true? (Choose two.)

A. CDB1 and CDB2 must be in shared undo mode.
B. A common user must exist in CDB2 with the CREATE PLUGGABLE DATABASE privilege.
C. All transactions in HR_PDB1 of CDB1 must commit before the cloning process starts.
D. Cloning HR_ROOT automatically clones HR_PDB1.
E. The HR_PDB1 clone created in CDB2 will be in mount state when cloning ends.

Show Suggested Answer

Suggested Answer: BD 🗳️

by veginha at June 22, 2020, 6:19 a.m.

Comments

Submit Cancel

mqdiri

Highly Voted 4 years, 3 months ago

BE After you create the application PDB, it is in mounted mode, and its status is NEW https://docs.oracle.com/en/database/oracle/oracle-database/21/multi/creating-application-pdb.html#GUID-88E61123-F651-47D7-9977-B589268EBD29

upvoted 12 times

...

2211094

Most Recent 1 year ago

CE C===To ensure data integrity E===According to Oracle documentation, after the cloning process is completed, the cloned PDB will be in the mount state. This allows the DBA to perform any additional configurations or checks before opening the PDB. https://docs.oracle.com/en/database/oracle/oracle-database/19/multi/cloning-a-pdb.html#GUID-D4900E43-DF38-4629-9A1F-D1C11EC8EC8F

upvoted 1 times

...

ismoil

1 year, 9 months ago

C E I think

upvoted 2 times

...

_gio_

2 years, 1 month ago

Selected Answer: BE

Sure of BE https://docs.oracle.com/en/database/oracle/oracle-database/19/multi/cloning-a-pdb.html#GUID-D4900E43-DF38-4629-9A1F-D1C11EC8EC8F

upvoted 1 times

...

ErikJanssen

2 years, 3 months ago

BC I think. After looking through https://oracle-base.com/articles/19c/multitenant-dbca-pdb-remote-clone-19c E is not correct, the remote pdb is open read write after being cloned. C could be true; Source database needs to be readonly if remote CDB is not in archivelog mode or does not have local undo enabled.

upvoted 1 times

...

jareach

2 years, 5 months ago

D, E in my opinion.

upvoted 1 times

...

Neil107

3 years, 11 months ago

It's B and E.

upvoted 1 times

...

Neil107

3 years, 11 months ago

It's B and E.

upvoted 2 times

...

cerebro2000x

4 years, 11 months ago

BE for me you need to clone the app root first and the pdb [separately] CREATE PLUGGABLE DATABASE hr_root_dev AS APPLICATION CONTAINER FROM hr_root@link_hr_root;

upvoted 2 times

cerebro2000x

4 years, 11 months ago

CREATE PLUGGABLE DATABASE operations_dev FROM operations@link_operations

upvoted 1 times

...

CyborgQ

4 years, 11 months ago

B,D are correct E incorrect: the clone can be done in read/write mode and the copy is in read/write mode

upvoted 1 times

SimoneF

4 years, 2 months ago

I didn't find any support to this claim. On the contrary, everything leads to think that, even in open mode, your cloned PDB will be mounted after the creation: "After you create the PDB, it is in mounted mode, and its status is NEW. " https://docs.oracle.com/en/database/oracle/oracle-database/21/multi/cloning-a-pdb.html#GUID-D4900E43-DF38-4629-9A1F-D1C11EC8EC8F

upvoted 5 times

...

veginha

5 years, 1 month ago

BE, but I'm not sure. Anyone know this?

upvoted 1 times

...