Oracle Multitenant PDB Administration Quiz

1. What is the maximum number of PDBs supported in a single CDB?

100

252

500

1000

2. Which view shows the current open PDB and its status in a multitenant database?

V$database

V$instance

V$container

V$pdb_status

3. True or False: You can have multiple CDBs running on the same server.

True

False

Submit

5. To drop a PDB while retaining its datafiles, which clause would you use?

DROP PLUGGABLE DATABASE KEEP DATAFILES

DROP PLUGGABLE DATABASE PRESERVE DATAFILES

DROP PLUGGABLE DATABASE INCLUDING DATAFILES

DROP PLUGGABLE DATABASE RETAIN FILES

6. Which background process manages redo log archiving for the entire CDB?

ARCH

LGWR

DBWR

CKPT

Submit

8. True or False: All PDBs in a CDB must have the same character set.

True

False

9. Which file contains initialization parameters specific to a PDB in a multitenant setup?

SpfileCDB.ora

SpfilePDB.ora

InitPDB.ora

Pdb_init.ora

10. To create a new PDB from the seed, which SQL statement would you use?

CREATE PLUGGABLE DATABASE

CREATE DATABASE

ALTER PLUGGABLE DATABASE

CREATE CONTAINER DATABASE

11. What is the primary container in an Oracle multitenant architecture called?

Pluggable Database (PDB)

Container Database (CDB)

Root Database (RDB)

Tenant Database (TDB)

Submit

13. Which command is used to switch from the CDB root to a PDB for administrative tasks?

ALTER SYSTEM SWITCH PDB

ALTER SESSION SET CONTAINER

SWITCH CONTAINER

ALTER DATABASE OPEN PDB

14. True or False: Each PDB in a CDB has its own control file and online redo logs.

True

False

Submit

16. Which parameter determines whether a PDB is opened automatically when the CDB starts?

Db_open_cursors

Db_recovery_file_dest

Db_name

Pdb_lockdown

17. What is the default administrative user for managing a CDB and its PDBs?

SYSTEM

SYS

ADMIN

DBADMIN

Submit

19. Which background process is responsible for managing PDB-specific data in a CDB?

PMON

SMON

DBRM

DBW0

Oracle DBA Professional Multitenant PDB Administration Quiz

1. What is the maximum number of PDBs supported in a single CDB?

2.

What first name or nickname would you like us to use?

2. Which view shows the current open PDB and its status in a multitenant database?

3. True or False: You can have multiple CDBs running on the same server.

4. The ______ parameter specifies the location where PDB datafiles and log files are created by default.

5. To drop a PDB while retaining its datafiles, which clause would you use?

6. Which background process manages redo log archiving for the entire CDB?

7. The ______ is a template PDB used to create new PDBs in a multitenant architecture.

8. True or False: All PDBs in a CDB must have the same character set.

9. Which file contains initialization parameters specific to a PDB in a multitenant setup?

10. To create a new PDB from the seed, which SQL statement would you use?

11. What is the primary container in an Oracle multitenant architecture called?

12. The ______ view displays information about all pluggable databases in a CDB.

13. Which command is used to switch from the CDB root to a PDB for administrative tasks?

14. True or False: Each PDB in a CDB has its own control file and online redo logs.

15. When you create a new PDB from a seed template, the process is known as ______.

16. Which parameter determines whether a PDB is opened automatically when the CDB starts?

17. What is the default administrative user for managing a CDB and its PDBs?

18. In a multitenant environment, the ______ contains the metadata and system objects shared by all PDBs.

19. Which background process is responsible for managing PDB-specific data in a CDB?