Examine the command to create a pluggable database (PDB):
SQL> CREATE PLUGGABLE DATABASE pdb2 FROM pdb1
FILE_NAME-_CONVERT = (‘/disk1 /oracle/pdb1 /’, ‘/disk2/oracle/pdb2/’) PATH_PREFIX =
‘/disk2/oracle/pdb2’;
Which two statements are true?
A.
The pluggable database pdb2 is created by cloning pdb1 and is in mount state.
B.
Details about the metadata describing pdb2 are stored in an XML file in the
‘/disk2/oracle/pdb2/’ directory.
C.
The tablespace specifications of pdb2 are the same as pdb1.
D.
All database objects belonging to common users in PD3I are cloned in PD32.
E.
pdb2 is created with its own private undo and temp tablespaces.
Explanation:
Reference:
http://oracle-info.com/2013/07/27/12c-database-create-pdbs-plug-unplug/ (see the table, 4th
row)
Hi,
The answers are wrong, you give only one answer and there is two.
The answers are wrong, you give only one answer and there is two.
A and C appear to be correct.
A and C
A and C
https://docs.oracle.com/database/121/ADMIN/cdb_plug.htm#ADMIN13586
Thanks Vonpire!
How about D?
AC
AC
AC
D – NOT Common user is created on CDB level.
This is local cloning so for sure
ALL objects belonging to common user are NOT cloned / duplicated 🙂
A,C
Arkadius -What do you mean by local cloning?
If CDB have some tables in source PBS – than these tables will be cloned to target PDB (tested). So for me D is also correct.
AC