Which three are true about creating container databases (CDBs) and pluggable databases (PDBs) in Oracle 19c and later releases? (Choose three.)
A.
A PDB snapshot can be a sparse copy of a source PDB.
B.
A PDB snapshot depends on an existing storage snapshot of the source PDB.
C.
A CDB can be duplicated using Recovery Manager (RMAN) with no configuration required before starting the duplication.
D.
A CDB can be duplicated using the Database Configuration Assistant (DBCA) in silent mode with no configuration required before starting the duplication.
E.
A PDB snapshot can be a full copy of a source PDB.
F.
A snapshot copy PDB can be a full copy of a source PDB.
G.
A snapshot copy PDB does not depend on an existing storage snapshot of the source PDB.
A, E, D
A, E sparse / full depending on storage
D - no configuration required:
https://docs.oracle.com/en/database/oracle/oracle-database/19/duplicate-cdbs-using-dbca-silent-mode/index.html
i think ABE
B > i think it depends on file system on storage > Storage Requirements for Snapshot Copy PDBs > https://docs.oracle.com/en/database/oracle/oracle-database/19/multi/cloning-a-pdb.html#GUID-E4EAE488-5371-4B8A-A839-2ADFA7507705
After labbed, I changed to ACE.
DBCA requires archive log - [FATAL] [DBT-16051] Archive log mode is not enabled in the primary database.
ACTION: Primary database should be configured with archive log mode for creating a duplicate or standby database.
[oracle@testbed-orcl8 ~]$
RMAN startup mount; > ALTER DATABASE OPEN READ ONLY (optional) > rman target / > BACKUP DATABASE;
No, G is incorrect. You've mistaken PDB snapshot copy for a PDB snapshot: https://docs.oracle.com/en/database/oracle/oracle-database/19/multi/cloning-a-pdb.html#GUID-B00A0E48-C892-4DC8-8455-C6F2ABC8EF91:~:text=Unlike%20a%20standard%20clone%20PDB%2C%20the%20snapshot%20copy%20PDB%20is%20dependent%20on%20the%20storage%20snapshot.
A and E supported by https://docs.oracle.com/en/database/oracle/oracle-database/19/multi/administering-pdb-snapshots.html#GUID-35B03C37-00BA-4945-BF20-9A7C4C541955
D supported by https://docs.oracle.com/en/database/oracle/oracle-database/19/duplicate-cdbs-using-dbca-silent-mode/index.html
In my opinion, the database being in archive mode does not characterize a configuration performed before the start of the process.
I think ADE is correct:
A and E: See Contents of a snapshot in https://docs.oracle.com/en/database/oracle/oracle-database/19/multi/administering-pdb-snapshots.html#GUID-35B03C37-00BA-4945-BF20-9A7C4C541955
D though requires archivelog mode, I do not think it is a configuration as meant in question.
B is incorrect because a snapshot copy PDB depends on a storage snapshot, not a snapshot. See Storage requirements for a snapshot copy PDBs https://docs.oracle.com/en/database/oracle/oracle-database/19/multi/cloning-a-pdb.html#GUID-E4EAE488-5371-4B8A-A839-2ADFA7507705
Unlike a standard clone PDB, the snapshot copy PDB is dependent on the storage snapshot. Therefore, you cannot unplug a snapshot copy PDB from the CDB root or plug it in to an application root. Also, you cannot drop the storage snapshot on which the PDB is based. Instead, you must materialize the snapshot copy PDB, which converts it into a full PDB with non-sparse files
In Oracle 18c the DBCA can now duplicate container databases. In the following example we have a container database called "cdb1". We use the following command to attempt
to create a new CDB called "cdb2" as a clone of "cdb1", but it fails because the source database is not in archivelog mode.
...
dbca -silent \
-createDuplicateDB \
-gdbName cdb2 \
-primaryDBConnectionString "localhost:1521/cdb1" \
-sid cdb2 \
-sysPassword SysPassword1
[FATAL] [DBT-16051] Archive log mode is not enabled in the primary database.
ACTION: Primary database should be configured with archive log mode for creating a duplicate or standby database.
ARCHIVELOG IS REQUIRED
D - INCORRECT
And then: ABE
Clarifying the Question...
D - the response specify that "no configuration required" but a previous configuration is required as "enable archivelog mode" and then D is INCORRECT as you can check in the laboratory output alteady typed.
Correct: ABE
I think ABE
https://docs.oracle.com/en/database/oracle/oracle-database/19/multi/administering-pdb-snapshots.html#GUID-FF6DF540-0C22-451C-80B3-1ACA8C8CB7D2
upvoted 3 times
...
Log in to ExamTopics
Sign in:
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.
mporislav
Highly Voted 3 years, 1 month agodancymonkey
Most Recent 4 months, 4 weeks agodancymonkey
4 months, 3 weeks agoismoil
8 months agoacesonly
3 weeks agoflaviogcmelo
9 months, 1 week ago_gio_
11 months, 1 week agovkra
1 year, 3 months agoErikJanssen
1 year, 4 months agoKushal22
1 year, 5 months agonabhan2001nabhan
4 months agomycert00
1 year, 8 months agomycert00
1 year, 8 months agodunhill
3 years agoRinD
3 years, 1 month ago