) 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.
Settings, administration, and their effects?
Which two are true about RMAN virtual private catalogs (VPCs)?
The RMAN catalog owner can grant access for an already registered database
To a new virtual catalog owner.
Each VPC is owned by the recovery catalog schema owner.
RMAN uses Oracle Virtual Private Database (VPD) to implement VPCs.
Only one target database can be registered in a VPC.
VPC functionality is enabled by default.
Container database?
Explicitly?
Which two are true about unplugging an application container from a
Container database and plugging it into a different container database?
Plugging the application root into a different CDB plugs in all its application
PDBs.
The application root of an application container should be plugged into the
Other CDB before its application PDBs are plugged in.
Application PDBs in the application container must be unplugged before the
Application root is unplugged.
Unplugging the application root from a CDB unplugs all its application PDBs.
Assistant (DBCA)?
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.
Database (CDB) and its pluggable databases (PDBs)?
If Automatic Memory Management is enabled, no memory advisors are
Available.
If Automatic Memory Management is enabled, the Shared Pool Advisor and
Buffer Cache Advisor are available to set the maximum size for these individual
System Global Area components.
All memory advisors use data from Automatic Workload Repository.
If Automatic Shared Memory Management is enabled, both the SGA Advisor
And PGA Advisor are always available.
Statements and their tuning in Oracle database instances?
Oracle software?
Stateless alerts can be cleared manually.
Stateless alerts are automatically cleared after one day.
Stateful alerts are purged automatically from the alert history after one day.
Stateless alerts can be purged manually from the alert history.
Stateful alerts must be cleared by a DBA to resolve the problem identified in the alert.
And services?
我来回答: