Which three are true about creating container databases (CDBs) and pluggable databases (PDBs) in Oracle 19c and later releases? (Choose three.)
Which three are true about creating container databases (CDBs) and pluggable databases (PDBs) in Oracle 19c and later releases? (Choose three.)
A PDB snapshot can be a sparse copy of a source PDB and can also be a full copy, covering A and E. These two provide a clear distinction between sparse and full copies, which are valid options in Oracle 19c and later releases. For option B, a PDB snapshot does depend on an existing storage snapshot of the source PDB, as the snapshot relies on storage-level functionality to maintain consistency and efficiency. These three options accurately represent features and dependencies of creating CDBs and PDBs.
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 https://docs.oracle.com/en/database/oracle/oracle-database/19/multi/administering-pdb-snapshots.html#GUID-FF6DF540-0C22-451C-80B3-1ACA8C8CB7D2
I think ADE. B: It depends on storage system, but may not be storage snapshot. (Personal Opinion)
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
Its ABE
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
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
A D E is correct
I'm sure of AE. C because DBCA need archivelog mode. duplicate prerequisites depends on the type of duplication but there are less restrictions
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.
A , E ,G is 100%
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.
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;