exam questions

Exam 1z0-083 All Questions

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

Exam 1z0-083 topic 1 question 114 discussion

Actual exam question from Oracle's 1z0-083
Question #: 114
Topic #: 1
[All 1z0-083 Questions]

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.
Show Suggested Answer Hide Answer
Suggested Answer: ABF 🗳️
Reference:
https://docs.oracle.com/en/database/oracle/oracle-database/19/multi/cloning-a-pdb.html#GUID-05702CEB-A43C-452C-8081-4CA68DDA8007

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
mporislav
Highly Voted 3 years, 1 month ago
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
upvoted 10 times
...
dancymonkey
Most Recent 4 months, 4 weeks ago
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
upvoted 1 times
dancymonkey
4 months, 3 weeks ago
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;
upvoted 1 times
...
...
ismoil
8 months ago
A , E ,G is 100%
upvoted 1 times
acesonly
3 weeks ago
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.
upvoted 1 times
...
...
flaviogcmelo
9 months, 1 week ago
Selected Answer: ADE
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.
upvoted 1 times
...
_gio_
11 months, 1 week ago
Selected Answer: ACE
I'm sure of AE. C because DBCA need archivelog mode. duplicate prerequisites depends on the type of duplication but there are less restrictions
upvoted 1 times
...
vkra
1 year, 3 months ago
Selected Answer: ADE
A D E is correct
upvoted 1 times
...
ErikJanssen
1 year, 4 months ago
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
upvoted 1 times
...
Kushal22
1 year, 5 months ago
Its ABE
upvoted 1 times
nabhan2001nabhan
4 months ago
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
upvoted 1 times
...
...
mycert00
1 year, 8 months ago
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
upvoted 1 times
mycert00
1 year, 8 months ago
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
upvoted 1 times
...
...
dunhill
3 years ago
I think ADE. B: It depends on storage system, but may not be storage snapshot. (Personal Opinion)
upvoted 3 times
...
RinD
3 years, 1 month ago
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
...
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.

SaveCancel
Loading ...
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago