Oracle Database Administration from Zero to Hero - Practice - Creating PDBs

This tutorial covers restoring a VM from a CDB snapshot, creating a BDB using SQL Plus, and testing connections to PDBs using the Easy Connect method. It also demonstrates creating a PDB with DBCA, retrieving PDB information, and cleaning up by dropping PDBs.

What is the first step in restoring SRV one from its CDB snapshot?

• Start the VM

• Open SQL Plus

• Connect to SRB one

• Shut down the VM

Which utility is used to create a pluggable database from the seed container?

• DBCA

• SQL Plus

• Putty

• Oracle Manager

What does the timing variable in SQL Plus display?

• The current time

• The time period elapsed by every statement

• The database size

• The number of users connected

In which mode is the newly created PDB initially opened?

• Closed mode

• Read-write mode

• Read-only mode

• Mount mode

What is the principle of the Easy Connect method?

• Connecting through a web interface

• Using a graphical user interface

• Using a complex connection string

• Specifying the database name and domain

Which option should be selected in the DBCA utility to create a new pluggable database?

• Delete existing database

• Open existing database

• Create a new pluggable database from the seed

• Manage Blockable Databases

What is the default open mode of a PDB created by the DBCA utility?

• Read-only mode

• Read-write mode

• Mount mode

• Closed mode

What is the format used for the directory of PDB data files?

• PDBGUID/OMF/CDB name/data file

• Data file/OMF/CDB name/PDBGUID

• CDB name/OMF/PDBGUID/data file

• OMF/CDB name/PDBGUID/data file

What must be done before dropping a pluggable database?

• Open the database

• Close the database

• Backup the database

• Rename the database

What is the purpose of the cleanup process in the practice?

• To backup the databases

• To drop the pluggable databases

• To create new databases

• To update the databases