Point-In-Time Recovery (TSPITR) using Recovery Manager (RMAN)?
It can be performed using an auxiliary instance managed by RMAN.
It can be performed using an auxiliary instance managed by a DBA.
It can be used to recover a truncated table.
It can be performed repeatedly until the correct time is found without using an
RMAN catalog.
RMAN always includes tablespaces containing UNDO segments
In the recovery set.
RMAN automatically adds any required tablespaces to the recovery set to
Make it selfcontained.
(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.
) They can only be written to disk.
) They can be encrypted using Transparent Data Encryption (TDE).
) They can be used as a level 0 incremental backup.
) They can be used as a level 1 incremental backup.
AUTOBACKUP by using RMAN?
Oracle container database?
Control file backups can be created while connected to the root container.
Archived Redo Log backups can be created while connected to an application root CDB.
Control file backups can be created while connected to a nonroot container.
Online Redo Log backups can be created while connected to the root container.
The BACKUP TABLESPACE command can back up a PDB tablespace even if RMAN is connected to CDB$ROOT.
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.
Auditing capabilities?
Application-common Transparent Security Data Protection (TSDP) policies can
Be created only if all the PDBs in the application container are closed.
Application-common TSDP policies are always container specific.
Application-common OLS policies can be created only if all the PDBs in the
Application container are closed.
Unified auditing can be automatically synchronized to all application PDBs in
An application container.
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.
(RHP), which has been available since Oracle 18c?
Multitenant environment?
Database (CDB) and its pluggable databases (PDBs)?
Statements and their tuning in Oracle database instances?
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.
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.
And services?
我来回答: