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 questions
Answer options
A:

A. A PDB snapshot is always a full copy of the source PDB.

B:

B. A PDB snapshot is always a sparse copy of the source PDB.

C:

C. A snapshot copy PDB depends on a storage snapshot which can only be stored on specific file systems.

Correct answer
D:

D. A PDB snapshot depends on a storage snapshot which can be stored on any file system.

E:

E. A PDB snapshot depends on a storage snapshot which can only be stored on specific file systems.

F:

F. A snapshot copy PDB depends on a storage snapshot which can be stored on any file system.

G:

G. A snapshot copy PDB can be created from a stand-alone clone PDB.

Correct answer
Correct Answer:
C. C. A snapshot copy PDB depends on a storage snapshot which can only be stored on specific file systems.; G. G. A snapshot copy PDB can be created from a stand-alone clone PDB.
Explanation

The 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).

Why Incorrect

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.

References

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.

Scroll to Top