Assistant (DBCA)?
) 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.
And services?
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.
Statements and their tuning in Oracle database instances?
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.
Settings, administration, and their effects?
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.
Oracle software?
Installation?
It includes the Oracle Preinstallation RPM.
From Oracle Database 18c, a single RPM can be used to install only Oracle
Database Server for a single instance.
It requires an Unbreakable Linux Network (ULN) subscription.
It performs a software-only Oracle Database installation.
Operating system scripts when performing silent mode installation starting
From Oracle Database 19c?
And its management in an Oracle database instance?
The entire PGA is located in the System Global Area (SGA) when using shared
Servers.
PGA_AGGREGATE_LIMIT is a hard limit on the PGA size for any one session.
The private SQL area (UGA) is located in the System Global Area (SGA) when
Using dedicated servers.
The private SQL area (UGA) is located in the System Global Area (SGA) when
Using shared servers.
Which two are true about the Optimizer Statistics Advisor?
It always analyzes all schemas in the database.
It can recommend changes to improve the statistics gathering process.
It can be run only manually.
It runs automatically every night by default.
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.
我来回答: