OCP Core Administration And Cdb Pdb Architecture — All Questions With Answers

Question 1easymultiple choice

Read the full Core Administration And Cdb Pdb Architecture explanation →

What is the default state of a PDB after creating it using the CREATE PLUGGABLE DATABASE command?

Question 2hardmultiple choice

Read the full Core Administration And Cdb Pdb Architecture explanation →

A PDB is in 'READ WRITE' mode. You need to perform a maintenance task that requires the PDB to be in 'RESTRICTED' mode. Which command achieves this?

Question 3mediummulti select

Read the full Core Administration And Cdb Pdb Architecture explanation →

When managing local and common users in a 23ai CDB, which TWO of the following statements are correct?

Question 4mediummultiple choice

Read the full Core Administration And Cdb Pdb Architecture explanation →

You are configuring a new CDB and want to ensure that PDBs use a common set of initialization parameters while allowing for specific overrides. Which parameter must be configured at the CDB level to allow local PDB parameter overrides?

Question 5easymultiple choice

Read the full Core Administration And Cdb Pdb Architecture explanation →

You are creating a new PDB from an existing one using the CREATE PLUGGABLE DATABASE command. Which clause must you include to ensure the new PDB has a different name and storage location?

Question 6hardmultiple choice

Read the full Core Administration And Cdb Pdb Architecture explanation →

When performing a 'Refreshable PDB Switchover', what is the state of the source PDB?

Question 7mediummultiple choice

Read the full Core Administration And Cdb Pdb Architecture explanation →

Which view should you query to see the current status of all PDBs in the CDB?

Question 8mediummultiple choice

Read the full Core Administration And Cdb Pdb Architecture explanation →

You want to limit the amount of memory a specific PDB can consume in a CDB. Which parameter should you configure?

Question 9easymultiple choice

Read the full Core Administration And Cdb Pdb Architecture explanation →

Which directory contains the Alert log for the CDB?

Question 10mediummultiple choice

Read the full Core Administration And Cdb Pdb Architecture explanation →

You are configuring a PDB to use Local Undo. What requirement must be met before setting the UNDO_TABLESPACE parameter?

Question 11hardmultiple choice

Read the full Core Administration And Cdb Pdb Architecture explanation →

In a 23ai CDB, which view reveals the mapping between PDBs and their associated services?

Question 12easymultiple choice

Read the full Core Administration And Cdb Pdb Architecture explanation →

Which initialization parameter determines the maximum number of PDBs allowed in a CDB?

Question 13mediummultiple choice

Read the full Core Administration And Cdb Pdb Architecture explanation →

Which privilege is required to perform a PDB unplug operation?

Question 14mediummultiple choice

Read the full Core Administration And Cdb Pdb Architecture explanation →

How can you verify if a PDB is encrypted?

Question 15hardmultiple choice

Read the full Core Administration And Cdb Pdb Architecture explanation →

If you want to use a PDB as a template for other PDBs, what state must the template PDB be in?

Question 16mediummultiple choice

Read the full Core Administration And Cdb Pdb Architecture explanation →

You need to capture PDB performance data. Which feature allows you to capture an AWR snapshot for a specific PDB?

Question 17easymultiple choice

Read the full Core Administration And Cdb Pdb Architecture explanation →

What is the purpose of the 'CDB_ROOT'?

Question 18easymultiple choice

Read the full Core Administration And Cdb Pdb Architecture explanation →

Which view displays the PDBs that are currently open in the CDB?

Question 19hardmultiple choice

Read the full Core Administration And Cdb Pdb Architecture explanation →

What happens to existing sessions when you issue 'ALTER PLUGGABLE DATABASE PDB1 CLOSE'?

Question 20mediummultiple choice

Read the full Core Administration And Cdb Pdb Architecture explanation →

Which dictionary view tracks the PDB creation time?

Question 21mediummultiple choice

Read the full Core Administration And Cdb Pdb Architecture explanation →

You need to create a PDB from a remote PDB. Which clause must be included in the CREATE PLUGGABLE DATABASE command?

Question 22hardmultiple choice

Read the full Core Administration And Cdb Pdb Architecture explanation →

Which feature allows you to perform point-in-time recovery for a specific PDB without affecting others?

Question 23easymultiple choice

Read the full Core Administration And Cdb Pdb Architecture explanation →

Which parameter defines the location of the PDB metadata files during a plug operation?

Question 24mediummultiple choice

Read the full Core Administration And Cdb Pdb Architecture explanation →

You need to monitor wait events for a specific PDB. Which view is most appropriate?

Question 25mediummulti select

Read the full Core Administration And Cdb Pdb Architecture explanation →

Which TWO views are essential for monitoring PDB-specific memory usage?

Question 26hardmulti select

Read the full Core Administration And Cdb Pdb Architecture explanation →

Which THREE actions occur when you execute 'ALTER PLUGGABLE DATABASE PDB1 OPEN'?

Question 27mediummulti select

Read the full Core Administration And Cdb Pdb Architecture explanation →

Which TWO parameters are critical for PDB resource management?

Question 28hardmultiple choice

Read the full Core Administration And Cdb Pdb Architecture explanation →

In a 23ai CDB, which command enables the automatic creation of PDBs when a non-CDB is plugged in?

Question 29hardmulti select

Read the full Core Administration And Cdb Pdb Architecture explanation →

Which THREE states can a PDB reside in?

Question 30mediummulti select

Read the full Core Administration And Cdb Pdb Architecture explanation →

Which TWO methods can be used to copy a PDB?

Question 31mediummulti select

Read the full Core Administration And Cdb Pdb Architecture explanation →

Which TWO views are used to check for plug-in compatibility?

Question 32mediummulti select

Read the full Core Administration And Cdb Pdb Architecture explanation →

Which TWO actions should be performed before dropping a PDB?

Question 33mediummulti select

Read the full Core Administration And Cdb Pdb Architecture explanation →

Which TWO tools can be used to perform PDB point-in-time recovery?

Question 34hardmulti select

Read the full Core Administration And Cdb Pdb Architecture explanation →

Which THREE parameters can be set at the PDB level?

Question 35hardmulti select

Read the full Core Administration And Cdb Pdb Architecture explanation →

Which THREE pieces of information are displayed when you run 'SHOW PDBS'?

Question 36mediummulti select

Read the full Core Administration And Cdb Pdb Architecture explanation →

Which TWO security features can be applied specifically to a PDB?

Question 37hardmulti select

Read the full Core Administration And Cdb Pdb Architecture explanation →

Which THREE steps are involved in upgrading a PDB?

Question 38mediummultiple choice

Read the full Core Administration And Cdb Pdb Architecture explanation →

You are configuring a new CDB and want to ensure that PDBs use only a specific subset of the CDB's total SGA memory while allowing individual PDBs to scale up when demand is high. Which parameter should you configure to enforce this?

Question 39easymultiple choice

Read the full Core Administration And Cdb Pdb Architecture explanation →

An administrator needs to perform maintenance on a specific PDB while keeping the rest of the CDB and other PDBs fully operational. What is the correct state to set the PDB to?

Question 40mediummultiple choice

Read the full Core Administration And Cdb Pdb Architecture explanation →

You need to ensure that the PDB$SEED template is updated with the latest patch level from the CDB. How should you proceed?

Question 41hardmultiple choice

Read the full Core Administration And Cdb Pdb Architecture explanation →

You observe that a PDB is consuming excessive UNDO tablespace. You want to implement 'Local Undo' mode for the CDB. What is the consequence of this change?

Question 42hardmultiple choice

Read the full Core Administration And Cdb Pdb Architecture explanation →

You are migrating a non-CDB database to a PDB in a 23ai CDB using the remote cloning method. Which condition must be met for the non-CDB to be successfully plugged in?

Question 43easymultiple choice

Read the full Core Administration And Cdb Pdb Architecture explanation →

A DBA needs to identify which PDBs are currently using more than their allocated TEMP tablespace quota. Which view should be queried?

Question 44mediummultiple choice

Read the full Core Administration And Cdb Pdb Architecture explanation →

You are troubleshooting a performance issue where background processes in a PDB are being throttled. You suspect an issue with the Resource Manager plan. How do you verify the current plan for a specific PDB?

Question 45mediummulti select

Read the full Core Administration And Cdb Pdb Architecture explanation →

Which THREE statements are true regarding the use of the 'ALTER PLUGGABLE DATABASE' command in a 23ai environment?

Question 46easymulti select

Read the full Core Administration And Cdb Pdb Architecture explanation →

Which THREE features are specific to the Multitenant architecture and distinguish a CDB from a non-CDB?

Question 47easymultiple choice

Read the full Core Administration And Cdb Pdb Architecture explanation →

You are preparing to create a new PDB named DEVPDB in your CDB, and you want it to be created as a clone of an existing PDB named APPPDB while APPPDB remains fully available to users. Which CREATE PLUGGABLE DATABASE clause accomplishes this?

Question 48easymultiple choice

Read the full Core Administration And Cdb Pdb Architecture explanation →

You are preparing to plug an unplugged PDB into a new CDB named NEWCDB. Before you run CREATE PLUGGABLE DATABASE, you want to verify that the XML metadata file describing the unplugged PDB is well-formed and that the datafiles it references exist in the expected location. Which view should you query from the CDB root to inspect the contents of an unplugged PDB's metadata while it is still unplugged?

Question 49mediummultiple choice

Read the full Core Administration And Cdb Pdb Architecture explanation →

You are the lead DBA for a CDB called PRODCDB. You need to relocate a PDB named SALESPDB to a different host. The PDB is currently open and has active transactions. You plan to unplug it. Which statement should you execute to ensure the PDB is in a consistent state for unplugging?

Question 50easymultiple choice

Read the full Core Administration And Cdb Pdb Architecture explanation →

You are managing a multitenant container database (CDB) with several pluggable databases (PDBs). You want to create a new PDB named HRPDB from the seed PDB. Which command correctly creates the PDB and leaves it in a mounted state?

Question 51mediummultiple choice

Read the full Core Administration And Cdb Pdb Architecture explanation →

You are the lead DBA for a CDB named PRODCDB. A developer has created an application PDB named APP1 and now reports that their application cannot connect to it. Upon investigation, you run the following query:

SELECT name, open_mode FROM v$pdbs WHERE name = 'APP1';

Output: NAME OPEN_MODE APP1 MOUNTED

The PDB has no local undo tablespace and its datafiles are all online. What is the most direct cause of the connection failure?

Question 52easymultiple choice

Read the full Core Administration And Cdb Pdb Architecture explanation →

You are a DBA for an Oracle 23ai CDB. You need to create a new PDB named TESTPDB from the seed PDB. Which command should you use?

Question 53mediummultiple choice

Read the full Core Administration And Cdb Pdb Architecture explanation →

You are managing a CDB and need to create a new PDB by cloning an existing PDB named SOURCEPDB. The clone should be named CLONEPDB and should be created from the local PDB without any intermediate files. Which command should you use?

Question 54easymultiple choice

Read the full Core Administration And Cdb Pdb Architecture explanation →

Which view provides information about the open status of all PDBs in a CDB?

Question 55hardmultiple choice

Read the full Core Administration And Cdb Pdb Architecture explanation →

You need to migrate a non-CDB to a PDB in an existing CDB. Which package should you use to check for compatibility issues before starting the migration?

Question 56mediummultiple choice

Read the full Core Administration And Cdb Pdb Architecture explanation →

You need to migrate a non-CDB database to a PDB in a 23ai CDB. Which utility is the recommended tool to assess compatibility before migration?

Question 57easymultiple choice

Read the full Core Administration And Cdb Pdb Architecture explanation →

What is the purpose of the 'Seed' PDB (PDB$SEED)?

Question 58hardmultiple choice

Read the full Core Administration And Cdb Pdb Architecture explanation →

Which command is used to move a PDB from one CDB to another without using Data Pump?

Question 59mediummultiple choice

Read the full Core Administration And Cdb Pdb Architecture explanation →

What happens when you execute 'ALTER PLUGGABLE DATABASE ALL OPEN'?

Question 60easymultiple choice

Read the full Core Administration And Cdb Pdb Architecture explanation →

What is the default behavior when shutting down a CDB instance?

Question 61mediummultiple choice

Read the full Core Administration And Cdb Pdb Architecture explanation →

Which file stores the metadata for a PDB being unplugged?

Question 62mediummultiple choice

Read the full Core Administration And Cdb Pdb Architecture explanation →

Which command allows you to change the state of a PDB to READ ONLY?

Question 63hardmultiple choice

Read the full Core Administration And Cdb Pdb Architecture explanation →

When using 'Snapshot Carousel', how many snapshots can a single PDB retain?

Question 64mediummultiple choice

Read the full Core Administration And Cdb Pdb Architecture explanation →

What is the primary benefit of using a 'Proxy PDB'?

Question 65hardmultiple choice

Read the full Core Administration And Cdb Pdb Architecture explanation →

You need to ensure that the PDB name is unique in your network. Which parameter should you check?

Question 66easymultiple choice

Read the full Core Administration And Cdb Pdb Architecture explanation →

Which command is used to display the current container you are connected to?

Question 67hardmultiple choice

Read the full Core Administration And Cdb Pdb Architecture explanation →

Which component is responsible for managing background processes across all containers in a CDB?

Question 68mediummultiple choice

Read the full Core Administration And Cdb Pdb Architecture explanation →

You are configuring a PDB. What happens to the PDB if you drop the CDB?

Question 69easymultiple choice

Read the full Core Administration And Cdb Pdb Architecture explanation →

What is the standard tool to manage CDB/PDB configuration in 23ai?

Question 70mediummultiple choice

Read the full Core Administration And Cdb Pdb Architecture explanation →

When a PDB is in 'RESTRICTED' mode, which sessions are allowed?

Question 71mediummulti select

Read the full Core Administration And Cdb Pdb Architecture explanation →

Which TWO tasks are required to successfully unplug a PDB?

Question 72hardmulti select

Read the full Core Administration And Cdb Pdb Architecture explanation →

Which THREE components are shared between a CDB and its PDBs?

Question 73hardmulti select

Read the full Core Administration And Cdb Pdb Architecture explanation →

Which THREE types of information are contained in the PDB XML metadata file?

Question 74hardmulti select

Read the full Core Administration And Cdb Pdb Architecture explanation →

Which THREE characteristics are unique to PDBs?

Question 75hardmulti select

Read the full Core Administration And Cdb Pdb Architecture explanation →

Which TWO actions are required when performing a 'Unplug and Plug' operation of a PDB between two different CDBs to ensure data integrity?

Question 76mediummultiple choice

Read the full Core Administration And Cdb Pdb Architecture explanation →

You are the lead DBA for a CDB named PRODCDB that contains a PDB named SALESPDB. A regulatory audit requires that SALESPDB be opened in READ ONLY mode for the next 48 hours, while all other PDBs in the CDB must remain fully available for normal application traffic. You connect to the root container as SYSDBA and execute: ALTER PLUGGABLE DATABASE SALESPDB OPEN READ ONLY; The command completes successfully. Which statement describes the resulting state of SALESPDB?

Question 77hardmultiple choice

Read the full Core Administration And Cdb Pdb Architecture explanation →

Your CDB named FINCDB has several PDBs. A developer reports that they cannot create a local user in the PDB named REPORTSPDB because the PDB is in RESTRICTED mode. You connect to the root as SYSDBA and want to allow normal user connections to REPORTSPDB while keeping other PDBs unchanged. Which command should you execute?

Question 78mediummultiple choice

Read the full Core Administration And Cdb Pdb Architecture explanation →

You are the lead DBA for a CDB called PRODCDB that contains 40 PDBs. An application team reports that connections to the PDB named SALESPDB intermittently fail with ORA-01033: ORACLE initialization or shutdown in progress, even though the CDB instance has been up for days. You query V$PDBS and notice SALESPDB shows a con_id of 5 and an open_mode of MOUNTED. Which action most directly restores application connectivity to SALESPDB?

Question 79mediummultiple choice

Read the full Core Administration And Cdb Pdb Architecture explanation →

You are the lead DBA for a CDB called PRODCDB that contains 30 PDBs. A developer reports that the application connecting to the PDB named SALESPDB receives ORA-01033 (Oracle initialization or shutdown in progress) when the database is otherwise available. You connect to the CDB root and query V$PDBS and see that SALESPDB shows OPEN_MODE of MOUNTED while all other PDBs show READ WRITE. Which command should you execute to make SALESPDB available to the application with the least administrative effort?

Question 80hardmultiple choice

Read the full Core Administration And Cdb Pdb Architecture explanation →

Your company runs a CDB named HQCDB with several PDBs. A junior DBA executed ALTER PLUGGABLE DATABASE HRPDB CLOSE IMMEDIATE; a few minutes later, users of HRPDB report that connections fail with ORA-01033. You query V$PDBS and observe that HRPDB shows OPEN_MODE of MOUNTED and RESTRICTED of NO. You need HRPDB fully available for read/write traffic with no restrictions. Which command should you run from the CDB root?

Question 81hardmultiple choice

Read the full Core Administration And Cdb Pdb Architecture explanation →

Your CDB is configured with a PDB named REPORTSPDB that must be opened automatically in READ ONLY mode every time the CDB instance starts, because it hosts static reporting data. Which two-step approach ensures this behavior across instance restarts? (Choose the best answer.)

Question 82mediummulti select

Read the full Core Administration And Cdb Pdb Architecture explanation →

You are the DBA for a CDB named CORPCDB that has several PDBs. You need to shut down the entire CDB instance cleanly, including all PDBs, as part of a planned maintenance window. Which two statements about the shutdown process are correct? (Choose two.)

Question 83mediummultiple choice

Read the full Core Administration And Cdb Pdb Architecture explanation →

A PDB named FINPDB in your CDB is currently open in READ WRITE mode and is actively serving users. You need to perform a planned maintenance operation that requires all user sessions to be disconnected and the PDB to be unavailable for new connections, but you want the operation to complete as quickly as possible without waiting for sessions to end naturally. Which command should you use?

Question 84hardmultiple choice

Read the full Core Administration And Cdb Pdb Architecture explanation →

You are administering a CDB with multiple PDBs. A developer reports that a query against a table in PDB1 returns an error indicating that the table does not exist, even though the table exists in the PDB. You connect to the CDB root and verify that the PDB is open. What is the most likely cause?

Question 85mediummultiple choice

Read the full Core Administration And Cdb Pdb Architecture explanation →

You are administering a CDB with several PDBs. You need to ensure that a specific PDB named HRPDB is automatically started and opened in READ WRITE mode whenever the CDB instance starts. Which action should you take?

Question 86hardmulti select

Read the full Core Administration And Cdb Pdb Architecture explanation →

You are managing a CDB named CDB1 with several PDBs. You need to create a new PDB named DEVPDB by cloning an existing PDB named PRODPDB. You want to minimize the impact on PRODPDB and ensure the clone is consistent. Which two statements are true regarding the CREATE PLUGGABLE DATABASE ... FROM PRODPDB command? (Choose two.)

Question 87hardmultiple choice

Read the full Core Administration And Cdb Pdb Architecture explanation →

You are administering a CDB with multiple PDBs. You need to ensure that a specific PDB named FINPDB automatically starts up when the CDB instance is started. Which action should you take?

Question 88mediummulti select

Read the full Core Administration And Cdb Pdb Architecture explanation →

You are a DBA for a CDB called CDB1. You need to monitor the performance of individual PDBs to identify which PDB is consuming the most resources. Which two views should you query to get PDB-level performance metrics and resource usage? (Choose two.)

Question 1easymultiple choice

Read the full Core Administration And Cdb Pdb Architecture explanation →

What is the default state of a PDB after creating it using the CREATE PLUGGABLE DATABASE command?

Question 2hardmultiple choice

Read the full Core Administration And Cdb Pdb Architecture explanation →

A PDB is in 'READ WRITE' mode. You need to perform a maintenance task that requires the PDB to be in 'RESTRICTED' mode. Which command achieves this?

Question 3mediummulti select

Read the full Core Administration And Cdb Pdb Architecture explanation →

When managing local and common users in a 23ai CDB, which TWO of the following statements are correct?

Question 4mediummultiple choice

Read the full Core Administration And Cdb Pdb Architecture explanation →

You are configuring a new CDB and want to ensure that PDBs use a common set of initialization parameters while allowing for specific overrides. Which parameter must be configured at the CDB level to allow local PDB parameter overrides?

Question 5easymultiple choice

Read the full Core Administration And Cdb Pdb Architecture explanation →

You are creating a new PDB from an existing one using the CREATE PLUGGABLE DATABASE command. Which clause must you include to ensure the new PDB has a different name and storage location?

Question 6hardmultiple choice

Read the full Core Administration And Cdb Pdb Architecture explanation →

When performing a 'Refreshable PDB Switchover', what is the state of the source PDB?

Question 7mediummultiple choice

Read the full Core Administration And Cdb Pdb Architecture explanation →

Which view should you query to see the current status of all PDBs in the CDB?

Question 8mediummultiple choice

Read the full Core Administration And Cdb Pdb Architecture explanation →

You want to limit the amount of memory a specific PDB can consume in a CDB. Which parameter should you configure?

Question 9easymultiple choice

Read the full Core Administration And Cdb Pdb Architecture explanation →

Which directory contains the Alert log for the CDB?

Question 10mediummultiple choice

Read the full Core Administration And Cdb Pdb Architecture explanation →

You are configuring a PDB to use Local Undo. What requirement must be met before setting the UNDO_TABLESPACE parameter?

Question 11hardmultiple choice

Read the full Core Administration And Cdb Pdb Architecture explanation →

In a 23ai CDB, which view reveals the mapping between PDBs and their associated services?

Question 12easymultiple choice

Read the full Core Administration And Cdb Pdb Architecture explanation →

Which initialization parameter determines the maximum number of PDBs allowed in a CDB?

Question 13mediummultiple choice

Read the full Core Administration And Cdb Pdb Architecture explanation →

Which privilege is required to perform a PDB unplug operation?

Question 14mediummultiple choice

Read the full Core Administration And Cdb Pdb Architecture explanation →

How can you verify if a PDB is encrypted?

Question 15hardmultiple choice

Read the full Core Administration And Cdb Pdb Architecture explanation →

If you want to use a PDB as a template for other PDBs, what state must the template PDB be in?

Question 16mediummultiple choice

Read the full Core Administration And Cdb Pdb Architecture explanation →

You need to capture PDB performance data. Which feature allows you to capture an AWR snapshot for a specific PDB?

Question 17easymultiple choice

Read the full Core Administration And Cdb Pdb Architecture explanation →

What is the purpose of the 'CDB_ROOT'?

Question 18easymultiple choice

Read the full Core Administration And Cdb Pdb Architecture explanation →

Which view displays the PDBs that are currently open in the CDB?

Question 19hardmultiple choice

Read the full Core Administration And Cdb Pdb Architecture explanation →

What happens to existing sessions when you issue 'ALTER PLUGGABLE DATABASE PDB1 CLOSE'?

Question 20mediummultiple choice

Read the full Core Administration And Cdb Pdb Architecture explanation →

Which dictionary view tracks the PDB creation time?

Question 21mediummultiple choice

Read the full Core Administration And Cdb Pdb Architecture explanation →

You need to create a PDB from a remote PDB. Which clause must be included in the CREATE PLUGGABLE DATABASE command?

Question 22hardmultiple choice

Read the full Core Administration And Cdb Pdb Architecture explanation →

Which feature allows you to perform point-in-time recovery for a specific PDB without affecting others?

Question 23easymultiple choice

Read the full Core Administration And Cdb Pdb Architecture explanation →

Which parameter defines the location of the PDB metadata files during a plug operation?

Question 24mediummultiple choice

Read the full Core Administration And Cdb Pdb Architecture explanation →

You need to monitor wait events for a specific PDB. Which view is most appropriate?

Question 25mediummulti select

Read the full Core Administration And Cdb Pdb Architecture explanation →

Which TWO views are essential for monitoring PDB-specific memory usage?

Question 26hardmulti select

Read the full Core Administration And Cdb Pdb Architecture explanation →

Which THREE actions occur when you execute 'ALTER PLUGGABLE DATABASE PDB1 OPEN'?

Question 27mediummulti select

Read the full Core Administration And Cdb Pdb Architecture explanation →

Which TWO parameters are critical for PDB resource management?

Question 28hardmultiple choice

Read the full Core Administration And Cdb Pdb Architecture explanation →

In a 23ai CDB, which command enables the automatic creation of PDBs when a non-CDB is plugged in?

Question 29hardmulti select

Read the full Core Administration And Cdb Pdb Architecture explanation →

Which THREE states can a PDB reside in?

Question 30mediummulti select

Read the full Core Administration And Cdb Pdb Architecture explanation →

Which TWO methods can be used to copy a PDB?

Question 31mediummulti select

Read the full Core Administration And Cdb Pdb Architecture explanation →

Which TWO views are used to check for plug-in compatibility?

Question 32mediummulti select

Read the full Core Administration And Cdb Pdb Architecture explanation →

Which TWO actions should be performed before dropping a PDB?

Question 33mediummulti select

Read the full Core Administration And Cdb Pdb Architecture explanation →

Which TWO tools can be used to perform PDB point-in-time recovery?

Question 34hardmulti select

Read the full Core Administration And Cdb Pdb Architecture explanation →

Which THREE parameters can be set at the PDB level?

Question 35hardmulti select

Read the full Core Administration And Cdb Pdb Architecture explanation →

Which THREE pieces of information are displayed when you run 'SHOW PDBS'?

Question 36mediummulti select

Read the full Core Administration And Cdb Pdb Architecture explanation →

Which TWO security features can be applied specifically to a PDB?

Question 37hardmulti select

Read the full Core Administration And Cdb Pdb Architecture explanation →

Which THREE steps are involved in upgrading a PDB?

Question 38mediummultiple choice

Read the full Core Administration And Cdb Pdb Architecture explanation →

You are configuring a new CDB and want to ensure that PDBs use only a specific subset of the CDB's total SGA memory while allowing individual PDBs to scale up when demand is high. Which parameter should you configure to enforce this?

Question 39easymultiple choice

Read the full Core Administration And Cdb Pdb Architecture explanation →

An administrator needs to perform maintenance on a specific PDB while keeping the rest of the CDB and other PDBs fully operational. What is the correct state to set the PDB to?

Question 40mediummultiple choice

Read the full Core Administration And Cdb Pdb Architecture explanation →

You need to ensure that the PDB$SEED template is updated with the latest patch level from the CDB. How should you proceed?

Question 41hardmultiple choice

Read the full Core Administration And Cdb Pdb Architecture explanation →

You observe that a PDB is consuming excessive UNDO tablespace. You want to implement 'Local Undo' mode for the CDB. What is the consequence of this change?

Question 42hardmultiple choice

Read the full Core Administration And Cdb Pdb Architecture explanation →

You are migrating a non-CDB database to a PDB in a 23ai CDB using the remote cloning method. Which condition must be met for the non-CDB to be successfully plugged in?

Question 43easymultiple choice

Read the full Core Administration And Cdb Pdb Architecture explanation →

A DBA needs to identify which PDBs are currently using more than their allocated TEMP tablespace quota. Which view should be queried?

Question 44mediummultiple choice

Read the full Core Administration And Cdb Pdb Architecture explanation →

You are troubleshooting a performance issue where background processes in a PDB are being throttled. You suspect an issue with the Resource Manager plan. How do you verify the current plan for a specific PDB?

Question 45mediummulti select

Read the full Core Administration And Cdb Pdb Architecture explanation →

Which THREE statements are true regarding the use of the 'ALTER PLUGGABLE DATABASE' command in a 23ai environment?

Question 46easymulti select

Read the full Core Administration And Cdb Pdb Architecture explanation →

Which THREE features are specific to the Multitenant architecture and distinguish a CDB from a non-CDB?

Question 47easymultiple choice

Read the full Core Administration And Cdb Pdb Architecture explanation →

You are preparing to create a new PDB named DEVPDB in your CDB, and you want it to be created as a clone of an existing PDB named APPPDB while APPPDB remains fully available to users. Which CREATE PLUGGABLE DATABASE clause accomplishes this?

Question 48easymultiple choice

Read the full Core Administration And Cdb Pdb Architecture explanation →

You are preparing to plug an unplugged PDB into a new CDB named NEWCDB. Before you run CREATE PLUGGABLE DATABASE, you want to verify that the XML metadata file describing the unplugged PDB is well-formed and that the datafiles it references exist in the expected location. Which view should you query from the CDB root to inspect the contents of an unplugged PDB's metadata while it is still unplugged?

Question 49mediummultiple choice

Read the full Core Administration And Cdb Pdb Architecture explanation →

You are the lead DBA for a CDB called PRODCDB. You need to relocate a PDB named SALESPDB to a different host. The PDB is currently open and has active transactions. You plan to unplug it. Which statement should you execute to ensure the PDB is in a consistent state for unplugging?

Question 50easymultiple choice

Read the full Core Administration And Cdb Pdb Architecture explanation →

You are managing a multitenant container database (CDB) with several pluggable databases (PDBs). You want to create a new PDB named HRPDB from the seed PDB. Which command correctly creates the PDB and leaves it in a mounted state?

Question 51mediummultiple choice

Read the full Core Administration And Cdb Pdb Architecture explanation →

SELECT name, open_mode FROM v$pdbs WHERE name = 'APP1';

Output: NAME OPEN_MODE APP1 MOUNTED

The PDB has no local undo tablespace and its datafiles are all online. What is the most direct cause of the connection failure?

Question 52easymultiple choice

Read the full Core Administration And Cdb Pdb Architecture explanation →

You are a DBA for an Oracle 23ai CDB. You need to create a new PDB named TESTPDB from the seed PDB. Which command should you use?

Question 53mediummultiple choice

Read the full Core Administration And Cdb Pdb Architecture explanation →

You are managing a CDB and need to create a new PDB by cloning an existing PDB named SOURCEPDB. The clone should be named CLONEPDB and should be created from the local PDB without any intermediate files. Which command should you use?

Question 54easymultiple choice

Read the full Core Administration And Cdb Pdb Architecture explanation →

Which view provides information about the open status of all PDBs in a CDB?

Question 55hardmultiple choice

Read the full Core Administration And Cdb Pdb Architecture explanation →

You need to migrate a non-CDB to a PDB in an existing CDB. Which package should you use to check for compatibility issues before starting the migration?

Question 56mediummultiple choice

Read the full Core Administration And Cdb Pdb Architecture explanation →

You need to migrate a non-CDB database to a PDB in a 23ai CDB. Which utility is the recommended tool to assess compatibility before migration?

Question 57easymultiple choice

Read the full Core Administration And Cdb Pdb Architecture explanation →

What is the purpose of the 'Seed' PDB (PDB$SEED)?

Question 58hardmultiple choice

Read the full Core Administration And Cdb Pdb Architecture explanation →

Which command is used to move a PDB from one CDB to another without using Data Pump?

Question 59mediummultiple choice

Read the full Core Administration And Cdb Pdb Architecture explanation →

What happens when you execute 'ALTER PLUGGABLE DATABASE ALL OPEN'?

Question 60easymultiple choice

Read the full Core Administration And Cdb Pdb Architecture explanation →

What is the default behavior when shutting down a CDB instance?

Question 61mediummultiple choice

Read the full Core Administration And Cdb Pdb Architecture explanation →

Which file stores the metadata for a PDB being unplugged?

Question 62mediummultiple choice

Read the full Core Administration And Cdb Pdb Architecture explanation →

Which command allows you to change the state of a PDB to READ ONLY?

Question 63hardmultiple choice

Read the full Core Administration And Cdb Pdb Architecture explanation →

When using 'Snapshot Carousel', how many snapshots can a single PDB retain?

Question 64mediummultiple choice

Read the full Core Administration And Cdb Pdb Architecture explanation →

What is the primary benefit of using a 'Proxy PDB'?

Question 65hardmultiple choice

Read the full Core Administration And Cdb Pdb Architecture explanation →

You need to ensure that the PDB name is unique in your network. Which parameter should you check?

Question 66easymultiple choice

Read the full Core Administration And Cdb Pdb Architecture explanation →

Which command is used to display the current container you are connected to?

Question 67hardmultiple choice

Read the full Core Administration And Cdb Pdb Architecture explanation →

Which component is responsible for managing background processes across all containers in a CDB?

Question 68mediummultiple choice

Read the full Core Administration And Cdb Pdb Architecture explanation →

You are configuring a PDB. What happens to the PDB if you drop the CDB?

Question 69easymultiple choice

Read the full Core Administration And Cdb Pdb Architecture explanation →

What is the standard tool to manage CDB/PDB configuration in 23ai?

Question 70mediummultiple choice

Read the full Core Administration And Cdb Pdb Architecture explanation →

When a PDB is in 'RESTRICTED' mode, which sessions are allowed?

Question 71mediummulti select

Read the full Core Administration And Cdb Pdb Architecture explanation →

Which TWO tasks are required to successfully unplug a PDB?

Question 72hardmulti select

Read the full Core Administration And Cdb Pdb Architecture explanation →

Which THREE components are shared between a CDB and its PDBs?

Question 73hardmulti select

Read the full Core Administration And Cdb Pdb Architecture explanation →

Which THREE types of information are contained in the PDB XML metadata file?

Question 74hardmulti select

Read the full Core Administration And Cdb Pdb Architecture explanation →

Which THREE characteristics are unique to PDBs?

Question 75hardmulti select

Read the full Core Administration And Cdb Pdb Architecture explanation →

Which TWO actions are required when performing a 'Unplug and Plug' operation of a PDB between two different CDBs to ensure data integrity?

Question 76mediummultiple choice

Read the full Core Administration And Cdb Pdb Architecture explanation →

You are the lead DBA for a CDB named PRODCDB that contains a PDB named SALESPDB. A regulatory audit requires that SALESPDB be opened in READ ONLY mode for the next 48 hours, while all other PDBs in the CDB must remain fully available for normal application traffic. You connect to the root container as SYSDBA and execute: ALTER PLUGGABLE DATABASE SALESPDB OPEN READ ONLY; The command completes successfully. Which statement describes the resulting state of SALESPDB?

Question 77hardmultiple choice

Read the full Core Administration And Cdb Pdb Architecture explanation →

Your CDB named FINCDB has several PDBs. A developer reports that they cannot create a local user in the PDB named REPORTSPDB because the PDB is in RESTRICTED mode. You connect to the root as SYSDBA and want to allow normal user connections to REPORTSPDB while keeping other PDBs unchanged. Which command should you execute?

Question 78mediummultiple choice

Read the full Core Administration And Cdb Pdb Architecture explanation →

You are the lead DBA for a CDB called PRODCDB that contains 40 PDBs. An application team reports that connections to the PDB named SALESPDB intermittently fail with ORA-01033: ORACLE initialization or shutdown in progress, even though the CDB instance has been up for days. You query V$PDBS and notice SALESPDB shows a con_id of 5 and an open_mode of MOUNTED. Which action most directly restores application connectivity to SALESPDB?

Question 79mediummultiple choice

Read the full Core Administration And Cdb Pdb Architecture explanation →

You are the lead DBA for a CDB called PRODCDB that contains 30 PDBs. A developer reports that the application connecting to the PDB named SALESPDB receives ORA-01033 (Oracle initialization or shutdown in progress) when the database is otherwise available. You connect to the CDB root and query V$PDBS and see that SALESPDB shows OPEN_MODE of MOUNTED while all other PDBs show READ WRITE. Which command should you execute to make SALESPDB available to the application with the least administrative effort?

Question 80hardmultiple choice

Read the full Core Administration And Cdb Pdb Architecture explanation →

Your company runs a CDB named HQCDB with several PDBs. A junior DBA executed ALTER PLUGGABLE DATABASE HRPDB CLOSE IMMEDIATE; a few minutes later, users of HRPDB report that connections fail with ORA-01033. You query V$PDBS and observe that HRPDB shows OPEN_MODE of MOUNTED and RESTRICTED of NO. You need HRPDB fully available for read/write traffic with no restrictions. Which command should you run from the CDB root?

Question 81hardmultiple choice

Read the full Core Administration And Cdb Pdb Architecture explanation →

Your CDB is configured with a PDB named REPORTSPDB that must be opened automatically in READ ONLY mode every time the CDB instance starts, because it hosts static reporting data. Which two-step approach ensures this behavior across instance restarts? (Choose the best answer.)

Question 82mediummulti select

Read the full Core Administration And Cdb Pdb Architecture explanation →

You are the DBA for a CDB named CORPCDB that has several PDBs. You need to shut down the entire CDB instance cleanly, including all PDBs, as part of a planned maintenance window. Which two statements about the shutdown process are correct? (Choose two.)

Question 83mediummultiple choice

Read the full Core Administration And Cdb Pdb Architecture explanation →

A PDB named FINPDB in your CDB is currently open in READ WRITE mode and is actively serving users. You need to perform a planned maintenance operation that requires all user sessions to be disconnected and the PDB to be unavailable for new connections, but you want the operation to complete as quickly as possible without waiting for sessions to end naturally. Which command should you use?

Question 84hardmultiple choice

Read the full Core Administration And Cdb Pdb Architecture explanation →

You are administering a CDB with multiple PDBs. A developer reports that a query against a table in PDB1 returns an error indicating that the table does not exist, even though the table exists in the PDB. You connect to the CDB root and verify that the PDB is open. What is the most likely cause?

Question 85mediummultiple choice

Read the full Core Administration And Cdb Pdb Architecture explanation →

You are administering a CDB with several PDBs. You need to ensure that a specific PDB named HRPDB is automatically started and opened in READ WRITE mode whenever the CDB instance starts. Which action should you take?

Question 86hardmulti select

Read the full Core Administration And Cdb Pdb Architecture explanation →

You are managing a CDB named CDB1 with several PDBs. You need to create a new PDB named DEVPDB by cloning an existing PDB named PRODPDB. You want to minimize the impact on PRODPDB and ensure the clone is consistent. Which two statements are true regarding the CREATE PLUGGABLE DATABASE ... FROM PRODPDB command? (Choose two.)

Question 87hardmultiple choice

Read the full Core Administration And Cdb Pdb Architecture explanation →

You are administering a CDB with multiple PDBs. You need to ensure that a specific PDB named FINPDB automatically starts up when the CDB instance is started. Which action should you take?

Question 88mediummulti select

Read the full Core Administration And Cdb Pdb Architecture explanation →

You are a DBA for a CDB called CDB1. You need to monitor the performance of individual PDBs to identify which PDB is consuming the most resources. Which two views should you query to get PDB-level performance metrics and resource usage? (Choose two.)