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

The video tutorial covers the process of creating Pluggable Databases (PDBs) in Oracle, focusing on methods using DBCA and SQL Developer. It outlines prerequisites, tools, and detailed steps for PDB creation, including using the CREATE PLUGGABLE DATABASE command. The tutorial also discusses managing PDBs, data file locations, and various SQL clauses for PDB configuration.

What is a prerequisite for creating a PDB?

• A new Oracle home must be installed.

• The current user must be a common user.

• A new database instance must be created.

• The CDB must be in read-only mode.

Which tool is primarily used in this course for creating PDBs?

• Oracle Enterprise Manager

• DBCA

• SQL Developer

• Cloud Control

What is the first step in creating a PDB using DBCA?

• Enter the SAS username and password.

• Select 'Manage Pluggable Databases'.

• Select the option to create a new database.

• Provide the new PDB name.

Which statement is used in Oracle SQL to create a new PDB?

• CREATE NEW PDB

• CREATE DATABASE

• CREATE PLUGGABLE DATABASE

• CREATE CONTAINER DATABASE

What does the FILE NAME CONVERT clause do?

• It defines the destination of the data files.

• It converts the database to a pluggable database.

• It changes the name of the PDB.

• It sets the default tablespace.

What is the purpose of the storage clause in PDB creation?

• To limit the amount of storage a PDB can use.

• To specify the data file location.

• To set the roles for the PDB.

• To define the default tablespace.

What happens when the no data clause is used?

• The PDB is created without any tablespaces.

• Data definitions are cloned, but not the data itself.

• All data is copied from the source PDB.

• The PDB is created with default data.