Question bank
Oracle Database Administration II
45 Oracle Database Administration II questions with the correct answer and a written explanation, organised across 8 exam domains.
- 45 questions
- 8 domains
- Foundation level
certilumQuestion index
Jump straight to any question. Answers and explanations are inline.
Application PDBs
5 questions in this domain
- Question 1Single Choice
What is an application PDB?
- AA PDB that is created inside an application rootCorrect answer
- BA PDB that is created directly in the CDB root
- CA PDB that does not belong to a container
- DA PDB used only for backup and recovery
Why this is the answer
An application PDB is a pluggable database that belongs to an application root in an application container. It is not plugged into the CDB root directly.
- Question 2Multiple Select
Which of the following are valid components of an Oracle application container? (Select all that apply.)
- AApplication rootCorrect answer
- BApplication PDBsCorrect answer
- CApplication seedCorrect answer
- DCDB root
Why this is the answer
An application container is composed of an application root and can include application PDBs and an application seed. The CDB root is above all application containers and is not a component of one.
- Question 3Interactive
You run the statement shown in the code block while connected to the root of the CDB. What component is created?
- AAn application rootCorrect answer
- BAn application PDB
- CAn application seed
- DA CDB root
Why this is the answer
The AS APPLICATION CONTAINER clause creates a PDB that acts as the application root. It does not by itself create an application seed or an application PDB.
- Question 4Single Choice
Which of the following best describes the purpose of an application seed?
- AIt acts as a template for creating application PDBs.Correct answer
- BIt stores mandatory tablespaces for the application root.
- CIt is used to back up the CDB root.
- DIt contains all archived redo logs for application PDBs.
Why this is the answer
An application seed is a special PDB template that helps create consistent application PDBs quickly. It is not used for logging or backup storage.
- Question 5Multiple Select
Which statements about application PDBs are true? (Select all that apply.)
- AAn application PDB is plugged into an application root.Correct answer
- BAn application PDB can be created from an application seed.Correct answer
- CAn application PDB is created in the CDB root by default.
- DAn application PDB cannot be associated with an application container.
Why this is the answer
Application PDBs belong to application roots and can be cloned from an application seed. They are not default CDB-root PDBs and are always associated with the application container.
Backup and Recovery
9 questions in this domain
- Question 6Single Choice
What is an application PDB in an Oracle multitenant environment?
- AA pluggable database inside an application containerCorrect answer
- BA database that replaces the CDB root
- CA PDB that is permanently read-only
- DA file set shared by every PDB
Why this is the answer
An application PDB is a pluggable database that belongs to an application container inside a CDB. It shares common objects managed through the application root.
- Question 7Multiple Select
Which two statements are true about application PDBs?
- AThey belong to an application containerCorrect answer
- BApplication changes from the app root can be synchronized into themCorrect answer
- CThey are standalone databases outside the CDB
- DThey must always remain in mount mode
Why this is the answer
An application PDB is a member of an application container. One key benefit is synchronizing application changes such as updates and patches from the application root to application PDBs.
- Question 8Interactive
Refer to the RMAN command in the code block. What is the outcome of running this command?
- AA backup of the application PDB named app_pdb1Correct answer
- BA backup of all PDBs in the CDB
- CA backup of the CDB root only
- DA backup of the application seed
Why this is the answer
RMAN uses BACKUP PLUGGABLE DATABASE with a PDB name to back up one specific pluggable database, including an application PDB.
- Question 9Single Choice
What is the purpose of the application root in an application container?
- AIt acts as the root for common objects and app PDBsCorrect answer
- BIt stores the archived redo logs for all CDBs
- CIt creates the control file for the CDB
- DIt replaces the recovery catalog
Why this is the answer
An application root is a PDB that serves as the container root for the application container. It stores common objects that can be shared by application PDBs.
- Question 10Multiple Select
Which two conditions are required before performing an online RMAN backup of an application PDB?
- AThe CDB must be in ARCHIVELOG modeCorrect answer
- BThe PDB must be accessible to RMANCorrect answer
- CThe PDB must be unplugged first
- DAll other PDBs must be shut down
Why this is the answer
Online RMAN backups need archive log mode so redo can be used for recovery. RMAN also must be able to access the target application PDB.
- Question 11Interactive
Refer to the RMAN command in the code block. What will RMAN display after this command is run?
- ABackups recorded for app_pdb1Correct answer
- BBackups recorded for the entire CDB
- CTablespace usage in app_pdb1
- DThe current status of the application seed
Why this is the answer
LIST BACKUP OF PLUGGABLE DATABASE shows backup information for a particular PDB, making it useful for checking backups that exist for app_pdb1.
- Question 12Single Choice
Which PDB is used as the default template for creating new application PDBs?
- AThe application seed PDBCorrect answer
- BThe application root PDB
- CThe CDB root
- DPDB$SEED
Why this is the answer
Application containers use an application seed PDB. New application PDBs created from the seed begin with the common structure provided by that seed.
- Question 13Multiple Select
Which two statements are true about RMAN backups of an application PDB?
- ARMAN can back up an application PDB independently from other PDBsCorrect answer
- BAn RMAN backup of an application PDB contains its PDB data filesCorrect answer
- CBacking up an application PDB also backs up the CDB root
- DApplication PDBs cannot be included in RMAN backups
Why this is the answer
RMAN supports PDB-level backup. The backup is made from data files belonging to the application PDB and does not automatically include the CDB root.
- Question 14Interactive
Refer to the RMAN command in the code block. What is the main action that RMAN takes?
- ARecover app_pdb1 by applying required archived redo logsCorrect answer
- BBack up app_pdb1 to tape
- CDrop app_pdb1 and recreate it
- DList all backups of app_pdb1
Why this is the answer
RECOVER PLUGGABLE DATABASE uses RMAN backups and archived redo logs to recover an application PDB after restoration or when redo must be applied.
Database Duplication
3 questions in this domain
- Question 15Single Choice
When a DBA reviews an Oracle multitenant database, which description best identifies an application PDB?
- ACreated inside an application containerCorrect answer
- BUsed solely as a CDB seed
- CConfigured only for Oracle Cloud
- DMounted as a read-only report store
Why this is the answer
An application PDB is created inside an application container. It is not just a seed, a cloud-only object, or a read-only reporting store.
- Question 16Multiple Select
Which statements below correctly describe how application PDBs relate to the application container in Oracle multitenant databases? Select all that apply.
- AThey are kept inside an application container.Correct answer
- BThey hold data and metadata for an application.Correct answer
- CThey are placed directly in the CDB root without a parent application container.
- DThey can be created only from a non-CDB backup.
Why this is the answer
Application PDBs belong to an application container and store application-specific data and metadata. They do not live directly in the CDB root and are not limited to non-CDB backups.
- Question 17Interactive
The code block creates a PDB named APP_ROOT. It must become an application root to host application PDBs. Which missing clause will make this happen?
- AAS APPLICATION CONTAINERCorrect answer
- BAS SEED
- CCONTAINER_MAP
- DFROM TEMPLATE
Why this is the answer
To configure a PDB as an application root, the CREATE PLUGGABLE DATABASE statement must include AS APPLICATION CONTAINER after the PDB name.
Flashback Technologies
3 questions in this domain
- Question 18Single Choice
Within the context of Oracle multitenant architecture, which statement best describes an Application PDB in a CDB?
- APDB inside an application rootCorrect answer
- BRoot of the CDB container
- CStand-alone PDB without an application root
- DTemplate used for creating PDBs
Why this is the answer
An Application PDB belongs to an application root and is part of an application container, not the CDB root or a seed template.
- Question 19Multiple Select
Within an Oracle application container, which two statements about Application PDBs are true? (Choose two.)
- APDB under an application rootCorrect answer
- BContainer root of the CDB
- CShares common objects from its application rootCorrect answer
- DNever synchronized with its application root
Why this is the answer
Application PDBs are contained in the application root and use common application objects installed there; they can also be synchronized with the app root.
- Question 20Interactive
You are connected to an application root and execute the following SQL statement. What object is created as a result?
- AA new Application PDB named sales_pdbCorrect answer
- BA new application root named sales_pdb
- CA new CDB root named sales_pdb
- DAn ordinary PDB linked to the CDB root
Why this is the answer
When CREATE PLUGGABLE DATABASE is run from an application root, the new PDB is an Application PDB.
Multitenant Architecture
8 questions in this domain
- Question 21Single Choice
In an Oracle multitenant container database, which type of container is the home for an application PDB?
- AApplication containerCorrect answer
- BCDB root
- CASM disk group
- DRecovery catalog
Why this is the answer
An application PDB is a PDB that is created in an application container, not in the CDB root, ASM, or recovery catalog.
- Question 22Multiple Select
Which two statements about application PDBs in an Oracle multitenant container database environment are correct?
- AThey are created inside an application container.Correct answer
- BThey can only be used by the CDB root.
- CThey can be opened and closed independently.Correct answer
- DThey do not need a data dictionary.
Why this is the answer
Application PDBs live inside an application container. Like other PDBs, they can be opened and closed independently; they also maintain a data dictionary.
- Question 23Interactive
Review the SQL code block and identify what container type is created by the statement.
- AApplication containerCorrect answer
- BApplication PDB
- CRegular PDB
- DCDB root
Why this is the answer
The AS APPLICATION CONTAINER clause makes the new PDB an application container in which application PDBs can later be created.
- Question 24Single Choice
In an Oracle application container, which container component stores the application common objects used by application PDBs?
- AApplication rootCorrect answer
- BEach application PDB
- CCDB root
- DOnline redo log
Why this is the answer
The application root is the container component that stores application common objects and makes them available to application PDBs.
- Question 25Multiple Select
When an administrator creates an application PDB, which two statements are true in an Oracle multitenant database?
- AConnect to the application root.Correct answer
- BConnect to the CDB root.
- CApplication container must already exist.Correct answer
- DPDB is created outside an application container.
Why this is the answer
An application PDB is created by connecting to the application root and creating a PDB inside an existing application container.
- Question 26Interactive
Review the code block and identify the current container name after the session container is set.
- AAPP_ROOTCorrect answer
- BCDB$ROOT
- CPDB$SEED
- DAPP_PDB
Why this is the answer
The session is changed to the app_root container, so SYS_CONTEXT returns APP_ROOT as the current container name.
- Question 27Single Choice
What is the name for a PDB that is contained by an application container in an Oracle multitenant database?
- AApplication PDBCorrect answer
- BRoot PDB
- CSeed PDB
- DProxy PDB
Why this is the answer
A PDB that belongs to an application container is called an application PDB, as distinct from the application root and application seed.
- Question 28Multiple Select
Within an Oracle multitenant environment, which two of the following are components found in an application container?
- AApplication rootCorrect answer
- BApplication PDBsCorrect answer
- CCDB root
- DLog writer process
Why this is the answer
An application container consists of the application root and the application PDBs assigned to that application container. The CDB root is separate.
Multitenant Security
4 questions in this domain
- Question 29Single Choice
Which statement correctly defines what an application PDB is in an Oracle Multitenant container database environment?
- AA PDB inside an application containerCorrect answer
- BA PDB that stores only CDB backups
- CA PDB detached from all containers
- DA replacement for the CDB root
Why this is the answer
An application PDB is a pluggable database that belongs to an application container. It stores user data and can share application common objects with other PDBs in that container.
- Question 30Multiple Select
Which two statements about application PDBs are true in an Oracle multitenant container database environment?
- AThey live in application containersCorrect answer
- BThey can share application common objectsCorrect answer
- CThey cannot be opened or closed
- DThey are copies of CDB root
Why this is the answer
Application PDBs belong to an application container and can mount application common objects used in application installs. They are normal PDBs and can be opened and closed as needed.
- Question 31Interactive
Review the SQL command in the code block. An administrator connected to an application root in Oracle Multitenant executes it. What happens?
- AStarts an application change transactionCorrect answer
- BShuts down the named PDB
- CUnplugs the named PDB
- DDeletes common application metadata
Why this is the answer
The APPLICATION BEGIN clause opens a transaction for application maintenance. Application installs or upgrades place operations between this command and APPLICATION END before changes become permanent or are rolled back.
- Question 32Single Choice
Which type of Oracle container must exist before an application PDB can be created and managed properly?
- AIn an application containerCorrect answer
- BIn the CDB root
- CInside a regular PDB
- DIn a non-CDB database
Why this is the answer
Application PDBs are created in an application container, not in the CDB root or a regular PDB. The application root gives them application common objects and version context.
Patching and Upgrades
5 questions in this domain
- Question 33Single Choice
What is an application PDB in an Oracle multitenant environment?
- AA regular PDB plugged into an application root that contains application data and metadataCorrect answer
- BThe root container that stores Oracle metadata for all PDBs
- CA PDB created only for storing Oracle patch bundles
- DA seed PDB used to create new application roots
Why this is the answer
An application PDB is a PDB that is plugged into an application root. It participates in the application container and contains application-specific data and metadata.
- Question 34Multiple Select
Which containers are part of an application container?
- AApplication rootCorrect answer
- BApplication seedCorrect answer
- CApplication PDBCorrect answer
- DCDB root
Why this is the answer
An application container consists of an application root, an application seed, and application PDBs. The CDB root is the root of the entire multitenant container database and is not part of an application container.
- Question 35Interactive
The code block shows a SQL statement. What kind of container is created when the statement is executed?
- AApplication rootCorrect answer
- BApplication PDB
- CApplication seed
- DCDB root
Why this is the answer
The clause AS APPLICATION CONTAINER creates an application root, which is the parent container for an application container.
- Question 36Single Choice
Which statement best describes an application seed?
- AA template used to create application PDBsCorrect answer
- BA copy of CDB$ROOT used to create new CDBs
- CA special PDB used only for application patching
- DA database link required for application upgrades
Why this is the answer
The application seed is a template PDB in the application container. It is used as a base for creating new application PDBs.
- Question 37Multiple Select
Which statements about application versions in an application container are correct?
- ADuring an upgrade, application PDBs can have different application versionsCorrect answer
- BThe application root can store multiple versions of an applicationCorrect answer
- CAll application PDBs must always be at exactly the same version
- DThe application seed is the only location for installing applications
Why this is the answer
Application upgrades are managed centrally in the application root, and individual application PDBs may remain at older versions until they are synchronized.
Performance and Tuning
8 questions in this domain
- Question 38Single Choice
Which statement best defines an application PDB when it is created inside an Oracle multitenant application container?
- AA PDB using an application rootCorrect answer
- BA PDB containing the whole CDB
- CA PDB created automatically by RMAN
- DA PDB that stores only AWR data
Why this is the answer
An application PDB belongs to an application container and shares application metadata through its application root.
- Question 39Multiple Select
Which two resource dimensions can a CDB resource plan allocate among application PDBs?
- ACPU usageCorrect answer
- BI/O usageCorrect answer
- CSCN value
- DAlert log size
Why this is the answer
A CDB resource plan can control resource allocation across PDBs, including CPU and I/O. SCN values and alert log sizes are not managed resources.
- Question 40Interactive
Examine the CREATE PLUGGABLE DATABASE statement in the code block. What type of container is created by this command?
- AApplication rootCorrect answer
- BApplication seed
- CApplication PDB
- DOS file system
Why this is the answer
The clause AS APPLICATION CONTAINER creates an application root, which is a PDB that can contain application PDBs.
- Question 41Single Choice
Which statement is true about the application seed inside an application container?
- ATemplate for app PDBsCorrect answer
- BStorage for alert logs
- CBackup of CDB root
- DRepository for optimizer stats
Why this is the answer
An application seed acts as a template that helps Oracle create application PDBs consistently within an application container.
- Question 42Multiple Select
Which two sections of an AWR PDB report are most useful when diagnosing an application PDB performance problem?
- ATop SQL statementsCorrect answer
- BWait event statisticsCorrect answer
- CRMAN backup schedule
- DPassword profile settings
Why this is the answer
AWR PDB reports include workload, SQL, and wait event data that help diagnose database performance issues.
- Question 43Interactive
The application upgrade is complete in the application root. What does the SQL command in the code block do when executed in an application PDB?
- ASync app PDB with rootCorrect answer
- BDrop the application root
- CRestart the CDB instance
- DConvert app PDB to seed
Why this is the answer
ALTER PLUGGABLE DATABASE APPLICATION ... SYNC updates the application PDB so it matches the application versions and metadata in its application root.
- Question 44Single Choice
What is an application common object in an Oracle multitenant application container?
- AShared metadata objectCorrect answer
- BPrivate user session
- CAutomatic undo segment
- DNetwork configuration file
Why this is the answer
An application common object is installed in the application root and is shared with application PDBs that synchronize with that root.
- Question 45Multiple Select
Which two statements correctly describe properties of an application PDB?
- APart of an app containerCorrect answer
- BCan sync with app rootCorrect answer
- CRequired in every CDB
- DCannot be opened or closed
Why this is the answer
Application PDBs live inside an application container and can synchronize shared objects with their application root, but they are optional and can be opened and closed independently.
Frequently asked questions
Everything about the Oracle Database Administration II question bank and how to use it.