Core Administration And Cdb Pdb Architecture

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?

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?

Which THREE characteristics are unique to PDBs?

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

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?

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

Which file stores the metadata for a PDB being unplugged?

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

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?

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.)

Which TWO tasks are required to successfully unplug a PDB?

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.)

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?

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

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

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?

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

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

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.)

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?

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?

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.)

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

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

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

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?

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

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

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?

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

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

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?

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

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

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