Oracle Database Administration from Zero to Hero - Practice - Performing Basic CDB Admin Tasks

This video tutorial covers essential CDB administration tasks, including changing the states of CDB and PDBs, modifying parameters at both CDB and PDB levels, and renaming and dropping PDBs. The tutorial provides step-by-step instructions on managing PDB states, modifying parameters, and handling PDBs within a CDB environment. It emphasizes the differences in operations when the current container is the root or a specific PDB, and demonstrates how to perform these tasks efficiently.

What is the primary focus of the CDB administration tasks introduced in the first section?

• Changing the global database name of a PDB

• Creating new PDBs

• Modifying BDB restart states and parameters in APDB

• Dropping existing PDBs

When shutting down a specific PDB, what is the effect of using the 'immediate' option?

• It prevents the PDB from shutting down

• It has no effect on the shutdown process

• It speeds up the shutdown process

• It delays the shutdown process

What command is used to close all PDPS in a single statement?

• ALTER PLUGGABLE DATABASE ALL CLOSE

• SHUTDOWN ALL PDPS

• CLOSE ALL PDPS

• STOP ALL PDPS

What happens to user-created PDPS when the entire CDP is shut down?

• They are backed up

• They are automatically closed

• They remain open

• They are deleted

Which parameter cannot be changed at the PDB level?

• Memory target

• DB recovery file disk size

• CPU count

• DDL lock timeout

What is the result of changing a parameter at the CDB level?

• It affects only the current PDB

• It affects all PDBs

• It affects only the root container

• It has no effect on any PDB

Which parameter is modifiable at the PDB level?

• CPU count

• Memory target

• DDL lock timeout

• DB recovery file disk size

What is the first step in changing the global database name of a PDB?

• Open the PDB in restricted mode

• Drop the existing PDB

• Create a new PDB from the seed

• Rename the PDB

After renaming a PDB, what should be done to verify the changes?

• Close and reopen the PDB

• Change the root container

• Create a new PDB

• Drop the PDB

What is the final step in the process of changing a PDB's global database name?

• Rename the PDB again

• Drop the new PDB including its data files

• Create a backup of the PDB

• Verify the changes