(Choose three.)
V$SESSION_EVENT displays all waits for all past and existing sessions if the
Wait has occurred at least once for a session.
V$SERVICE_EVENT displays all waits for all services if the wait has occurred at
Least once for a service.
V$SESSION_WAIT _CLASS displays waits broken down by wait class only for
Waiting sessions.
V$SESSION_WAIT and V$SESSION both contain details of the event on which
A non-waiting session last waited.
(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.
RMAN?
RMAN can recover tables owned by the SYSTEM user.
RMAN can recover tables owned by the SYS user.
RMAN can recover tables in the SYSTEM tablespace.
RMAN always uses an auxiliary instance.
(AWR) and Automatic Database Diagnostic Monitor (ADDM) in an Oracle
Multitenant environment?
Existing CDB with RMAN?
When upgrading an Oracle database using Database Upgrade Assistant?
Any Recovery Manager (RMAN) recovery catalog must be upgraded manually.
After a manual upgrade, TNSNAMES.ORA entries must be updated to reflect
The new ORACLE_HOME.
Time zone files must be upgraded manually using the DBMS_DST PL/SQL
Package.
The new extended data type capability must be enabled by running the
Utlrp.sql script
(RHP), which has been available since Oracle 18c?
Which three are true about SGA memory management in a multitenant
Database?
Which three are true about actions that can or cannot be performed by users
With the SYSBACKUP privilege?
They can view data from any data dictionary view or dynamic performance
View.
They can drop any tablespace.
They can view data from any user-defined tables.
They can create any table.
They cannot create restore points.
They cannot drop tablespaces.
Which three are true about interpreting Recovery Manager (RMAN) error
Stacks returned to standard output?
If an RMAN command fails, the output will only identify the command that
Failed.
Some messages in the error stack are not errors.
If an RMAN command fails, the output will identify the channel ID where the
Failure occurred.
Media Management errors appear as a line with "Additional information" and
A number.
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.
) It is used in both clustered and non-clustered environments.
) You can add and remove components from an Oracle Restart configuration
With Server Control (SRVCTL) commands.
) It runs from the Oracle Grid Infrastructure home.
) If you shut down a database instance with SQL*Plus, Oracle Restart interprets
This as a database failure and attempts to restart the instance.
我来回答: