Oracle Database Administration from Zero to Hero - Creating PDBs (Part 2 of 2)

This video tutorial covers the process of creating, cloning, and dropping Pluggable Databases (PDBs) in Oracle. It explains the steps to create a PDB from a seed, including setting up a local administrator and opening the PDB in read-write mode. The tutorial also provides examples of PDB creation with different parameters and discusses cloning a PDB, highlighting the conditions required for cloning. Finally, it outlines the procedure for dropping a PDB and the options available for managing data files.

What is the first step in creating a PDB from the seed?

• Open the PDB in read-only mode

• Connect to the root as a common user with CREATE PLUGGABLE DATABASE privilege

• Define the storage clause

• Take a backup of the PDB

Which parameter is used to define the destination of new PDB data files if FILE NAME CONVERT is not used?

• DB CREATE FILE DISK

• OMF

• DB STORAGE LIMIT

• PDB FILE NAME CONVERT

What must be ensured about each PDB in a CDB?

• It must be in read-only mode

• It must have a unique identifier

• It must be connected to the root

• It must have a storage limit

Under what condition can a PDB be cloned in read-write mode?

• If the CDB is running in archive log mode and local undo is enabled

• If the PDB is in read-only mode

• If the PDB is closed

• If the CDB is of release 12.1

What must be done before dropping a PDB?

• Clone it

• Connect to the root

• Open it in read-write mode

• Unplug it

What does the 'Keep Data Files' option do when dropping a PDB?

• Deletes the data files

• Returns the data files associated with the PDB

• Clones the data files

• Converts the data files

What is required to specify the 'Including Data Files' option when dropping a PDB?

• The PDB must be cloned

• The PDB must be in read-only mode

• The PDB must be closed or unplugged

• The PDB must be open