Snapshots in Oracle 19c and later releases? (Choose two.)
A PDB snapshot is always a full copy of the source PDB.
A PDB snapshot is always a sparse copy of the source PDB.
A snapshot copy PDB depends on a storage snapshot which can only be
Stored on specific file systems.
A PDB snapshot depends on a storage snapshot which can be stored on any
File system.
A PDB snapshot depends on a storage snapshot which can only be stored on
Specific file systems.
Database (CDB) and its pluggable databases (PDBs)?
And services?
Oracle software?
) 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.
It is not possible if an archived log is missing.
It is performed automatically after the database is opened; however, blocks
Requiring recovery are not available until they are recovered.
Setting FAST_START_MTTR_TARGET to a lower value reduces instance
Recovery time by causing
Dirty buffers to be written to disk more frequently, thereby reducing the number
Of I/Os needed during instance recovery.
It is performed by the Recovery Writer (RVWR) background process.
It is performed automatically while the database remains in MOUNT state.
Then the database is opened.
Oracle Database 19c later releases? (Choose two.)
Space is always reclaimed automatically when the retention period for
Flashback logs is lowered.
Space might be reclaimed proactively before space pressure occurs.
Space might be reclaimed automatically when the retention period for
Flashback logs is lowered.
Space is only reclaimed when there is space pressure in the Fast Recovery Area.
(FRA)
Message output? (Choose two.)
Media Management messages for SBT devices are always written to sbtio.log.
RMAN error stacks should be read from the bottom up as that is the order in
Which errors are generated.
RMAN error stacks should be read from the top down as that is the order in
Which errors are generated.
The RMAN LOG command line clause causes output issued during RMAN
Command
Compilation to be written to a log file and to standard output.
The RMAN LOG command line clause causes output issued during RMAN
Command compilation to be written to a log file only.
Media Management messages for
SBT devices are written to an Oracle trace file.
Settings, administration, and their effects?
Assistant (DBCA)?
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.
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.
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.
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.
Statements and their tuning in Oracle database instances?
我来回答: