Oracle Database Administration from Zero to Hero - Basic Multitenant Administration Tasks

This lecture covers multi-tenant administration tasks in Oracle Database, focusing on switching containers, managing CDB and PDB states, saving PDB open states, and handling initialization parameters. It explains the concept of containers, how to switch between them, and the importance of closing transactions before switching. The lecture also details the commands for changing CDB and PDB states, managing initialization parameters, and changing the global database name. Key differences between CDB and PDB states are highlighted, along with the procedure for renaming a PDB.

What is one of the tasks you will learn by the end of the lecture?

• Create a new database

• Switch the current container

• Delete a PDB

• Backup the entire CDB

In Oracle Database multi-tenancy, what does the term 'container' refer to?

• Only the CDB

• Only application PDBs

• Any PDB in the CDB, including the root

• Only the root container

What must be done before switching to another PDB during a transaction?

• Save the current state

• Switch to the root container

• Open a new transaction

• Close the current transaction

Which command is used to display the current container in a SQL Plus session?

• SHOW DATABASE

• SHOW CON ID

• SHOW CONTAINER

• SHOW SESSION

What is a key difference between the states of a CDB and a non-CDB database?

• CDBs cannot be shut down

• PDBs cannot be in the no mount state

• CDBs have a unique shutdown state

• PDBs can be in the no mount state

Which command is used to change the state of a PDB?

• ALTER PLUGGABLE DATABASE

• MODIFY PDB STATE

• UPDATE PDB STATUS

• CHANGE PDB MODE

What happens if you issue the shutdown command while the current container is the root?

• Only the root container shuts down

• All PDBs remain open

• The entire CDB shuts down

• Only the current PDB shuts down

How can you make a specific PDB automatically start up when the CDB is started?

• Modify the CDB configuration

• Use the command AUTO START PDB

• Set the PDB to the desired state and save it

• Use the command STARTUP AUTO

What is the purpose of the ALTER SYSTEM command with the option container equal to ALL?

• To change a parameter value for a specific PDB

• To shut down all PDBs

• To change a parameter value for all PDBs

• To reset all parameters to default

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

• Open the PDB in read-only mode

• Close the PDB

• Change the current container

• Issue the rename command