Which three conditions must be true for successful exec…

Examine this command:

SQL> CREATE PLUGGABLE DATABASE pdb3 FROM pdb1;

Which three conditions must be true for successful execution of this command on a RAC database? (Choose three.)

Examine this command:

SQL> CREATE PLUGGABLE DATABASE pdb3 FROM pdb1;

Which three conditions must be true for successful execution of this command on a RAC database? (Choose three.)

A.
It can be executed only by a common user with the CREATE PLUGGABLE DATABASE system privilege connected to the root container.

B.
The source PDB must use a global temporary tablespace.

C.
The source PDB must be in READONLY mode on all CDB instances.

D.
Oracle Managed Files must be enabled or PDB_FILE_NAME_CONVERT must be set.

E.
All running CDB instances must be open in restricted mode.

F.
The source PDB must be closed on the CDB instance from where the command is executed.



Leave a Reply 3

Your email address will not be published. Required fields are marked *


JAG

JAG

A. CREATE PLUGGABLE DATABASE system privilege and execute the CREATE PLUGGABLE DATABASE statement

C. source PDB needs to be in READ ONLY mode in all CDB instances.

D. Oracle Managed Files must be enabled or PDB_FILE_NAME_CONVERT must be set.