Oracle Database Administration from Zero to Hero - Oracle Database Multitenant Architecture (Part 2 of 2)

The lecture covers the structure and usage of CDB and PDB views in Oracle databases, focusing on identifiers like CON_ID, CON_UID, and GUID. It explains common files and parameters in CDBs, the distinction between local and common users, and the process of creating multi-tenant databases using DBCA. The lecture concludes with a summary and learning objectives.

What is the purpose of the CON_ID column in CDB views?

• To list all tablespaces

• To distinguish records from different PDBs

• To identify the root container

• To store the name of the PDB

Which identifier remains unchanged when a PDB is moved between CDBs?

• CON_ID

• PDB_NAME

• CON_UID

• GUID

What is the role of the SP file in a CDB?

• Holds temporary tablespaces

• Lists all PDBs

• Contains parameters affecting the entire CDB

• Stores user data

Why is it recommended to create separate temporary tablespaces for each PDB?

• To improve query performance

• To reduce storage costs

• To simplify backup processes

• To control the maximum size consumed by each PDB

What is a local user in Oracle multi-tenant architecture?

• A user known across all PDBs

• A user with administrative privileges

• A user defined in the root container

• A user defined within a specific PDB

Which type of user can perform administrative operations like creating a PDB?

• Local user

• Common user

• Guest user

• Root user

What is the main difference when creating a CDB using DBCA compared to a non-CDB?

• The need to specify a root password

• The option to create as a container database

• The requirement for additional storage

• The inclusion of a backup plan

What is the advantage of using local undo tablespaces in a CDB?

• Reduces the need for backups

• Improves query performance

• Allows point-in-time recovery for specific PDBs

• Simplifies database management

How many PDBs can be created without a multi-tenancy license in Oracle Database 19c?

• Two

• Three

• Unlimited

• One

What happens if the local undo option is disabled in a CDB?

• Each PDB will have its own undo tablespace

• The CDB will not function properly

• All PDBs will share the same undo tablespace

• Undo tablespaces will not be created