Core Administration And Cdb Pdb Architecture

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

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

Which THREE characteristics are unique to PDBs?

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

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

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?

Which TWO methods can be used to copy a PDB?

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

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

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

Which file stores the metadata for a PDB being unplugged?

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

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

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

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 want to limit the amount of memory a specific PDB can consume in a CDB. Which parameter should you configure?

Which TWO tasks are required to successfully unplug a PDB?

Which TWO parameters are critical for PDB resource management?

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

Which directory contains the Alert log for the CDB?

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

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?

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

Which THREE parameters can be set at the PDB level?

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

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?

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?

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

Which THREE steps are involved in upgrading a PDB?

How can you verify if a PDB is encrypted?

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

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

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

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

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

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

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?

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?

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?

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

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

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?

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

Which TWO actions should be performed before dropping a PDB?

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

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

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

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

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

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

What is the purpose of the 'CDB_ROOT'?

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

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?

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

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?

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?

Which privilege is required to perform a PDB unplug operation?

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

Which dictionary view tracks the PDB creation time?