1Z0-083 practice question 17 of 35
Which two are true about creating pluggable databases (PDBs) using snapshots in Oracle 19c and later releases? (Choose two.)
Full set: 286 questionsThe PDB snapshot copy feature creates a space-efficient, thin-provisioned clone of a source PDB. This functionality is not universally available and depends on the underlying storage technology. It is supported only on specific file systems like Oracle ACFS or for databases on dNFS storage where the storage appliance supports snapshots (C). The source for a snapshot copy can be any PDB, including a PDB that was itself created as a full clone from another PDB. Therefore, creating a snapshot copy from a "stand-alone clone PDB" is a valid operation (G).
A. A snapshot copy is a space-efficient, copy-on-write clone, not a full physical copy of all data blocks.
B. While it is a sparse or thin-provisioned copy, stating it is always a sparse copy can be imprecise; the key characteristics are its dependency and source flexibility.
D. The feature is not supported on all file systems; it has specific storage and file system prerequisites.
E. This is a correct statement, but option C uses the more precise official term "snapshot copy PDB". In a multiple-choice context, C is slightly better.
F. This is incorrect. The snapshot copy feature has specific file system requirements and is not supported on any file system.
1. Oracle Multitenant Administrator's Guide, 19c, "Creating a PDB Using the Snapshot Copy Feature". It states, "The snapshot copy feature is supported for PDBs whose data files reside on Oracle Automatic Storage Management Cluster File System (Oracle ACFS) or a direct NFS (dNFS) file system." This supports option C.
2. Oracle Multitenant Administrator's Guide, 19c, "About Creating a PDB". The guide does not place restrictions on the source PDB being an original or a clone, meaning any PDB can be a source. This supports option G.
3. Oracle SQL Language Reference, 19c, "CREATE PLUGGABLE DATABASE". The documentation for the SNAPSHOT COPY clause details the file system dependencies.
Keep practicing
Take the free 1Z0-083 practice test
Ten exam-style questions with answers and explanations, plus the exam facts and study guides.
More questions
Other 1Z0-083 practice questions
- Question 1Which two are true about flashback features in Oracle Database 19c and later releases? (C…
- Question 2Which two statements are true about Resource Manager plans for individual pluggable datab…
- Question 3Choose three. Which are the three steps in the SQL tuning process for Oracle Database env…
- Question 4Choose three. Which three are true about using Database Upgrade Assistant (DBUA) to upgra…
- Question 5Choose three. Which three capabilities require the use of the RMAN recovery catalog?
- Question 6Choose two. In which two situations can you use Database Upgrade Assistant?
