Oracle Database Administration from Zero to Hero - Practice - Creating a CDB Database

This video tutorial covers managing Oracle CDB and non-CDB databases using VirtualBox snapshots. It guides through creating and managing snapshots, setting up a CDB database with DBCA in silent mode, and exploring PDBs and containers. The tutorial also includes creating an HR schema and running queries in PDBs, concluding with finalizing and creating a snapshot for the CDB database.

What is the primary purpose of creating two VirtualBox snapshots in this course?

• To manage different versions of the same database

• To test different database configurations

• To switch between non-CDB and CDB databases

• To backup the database regularly

Which tool is used to drop the existing database and create a new CDB database?

• Oracle VirtualBox Manager

• Oracle Enterprise Manager

• Oracle Data Pump

• Oracle SQL Developer

What is the purpose of the adbca response file in the database creation process?

• To automate the database backup

• To define the parameters for creating a CDB database

• To configure network settings

• To manage user permissions

How can you verify that the database is up and running?

• By restarting the database

• By querying the database as sys DBA

• By checking the database logs

• By checking the server status

Which SQL command is used to list the existing PDBs?

• SHOW PDBS

• DISPLAY PDBS

• LIST PDBS

• SHOW DATABASES

What is the con ID for the seed in the database?

• 3

• 1

• 4

• 2

Where are the PDB data files created in relation to the root data files?

• In the same directory

• In a subdirectory of the root data files directory

• In a separate directory

• In the cloud storage

What command is used to change the current container to PDB1?

• SWITCH TO PDB1

• SET CONTAINER PDB1

• CHANGE CONTAINER TO PDB1

• ALTER SESSION SET CONTAINER = PDB1

Why can't the HR schema script be run in the root container?

• Because the root container is read-only

• Because user data must be saved in a PDB

• Because the script is incompatible with the root container

• Because the root container is not accessible

What is the root container name always referred to as?

• CDB$ROOT

• ROOT$CDB

• CDB_ROOT

• ROOT_CDB