An application container?
An application root clone gets created automatically.
The upgrade can be performed when connected either to CDB$ROOT or to
PDB$SEED.
After an application upgrade, the application container's PDBs remain
Synchronized with the existing application root.
The upgrade must be performed when connected to CDB$ROOT.
(TDE)?
A backup set may be duplexed with both copies written to disk.
An image copy on disk can be copied to disk.
A backup set may be duplexed with both copies written to sbt.
A backup set may be duplexed so that one copy is written to sbt and the other
To disk.
Catalog with a pluggable database (PDB) target connection in Oracle
Database 19c and later releases?
The base catalog owner must give the Virtual Private Catalog access to
Metadata for one or more PDBs.
The target PDB must be registered in both the base catalog and the Virtual Private Catalog.
The base catalog must be used by RMAN when performing point-in-time
Recovery for the PDB registered in the Virtual Private Catalog.
The base catalog must be enabled for Virtual Private Catalog use.
Active database duplication?
It considers the filters in WHERE clauses when generating execution plans for SQL statements.
It obeys all hints.
It considers object statistics when generating execution plans for SQL statements.
It updates stale object statistics in the Data Dictionary.
It can re-optimize execution plans after previous executions detect suboptimal plans.
(AWR) and Automatic Database Diagnostic Monitor (ADDM) in an Oracle
Multitenant environment?
Which three are true about creating container databases (CDBs) and
Pluggable databases (PDBs) in Oracle 19c and later releases?
A snapshot copy PDB can be a full copy of a source PDB.
A snapshot copy PDB does not depend on an existing storage snapshot of the
Source PDB.
A PDB snapshot depends on an existing storage snapshot of the source PDB.
A PDB snapshot can be a full copy of a source PDB.
They are installed via OPatch or OPatchAuto.
A base release is not needed to install patchsets.
They can be applied in a rolling fashion for Clusterware and the databases.
Installing a patchset is considered an "upgrade."
They can introduce new features.
They are only released quarterly.
Their recovery in an Oracle Database?
If a row lock is held by a nonexistent transaction, the block containing the row
Is media corrupt.
DB_BLOCK_CHECKING=TRUE causes a check sum to be added to each data
Block to help detect physical or media corruption.
A media corrupt block is one where the block is not formatted correctly.
The ANALYZE TABLE VALIDATE STRUCTURE CASCADE command verifies that
Each table row has an index entry pointing to it.
Multitenant environment?
我来回答: