Repository (AWR)?
All AWR tables belong to the SYSTEM schema.
The AWR data is stored in memory and in the database.
The snapshots collected by AWR are used by the self-tuning components in the database
AWR computes time model statistics based on time usage for activities, which
Are displayed in t he v$SYS time model and V$SESS_TIME_MODEL views.
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.
Which three are true about SGA memory management in a multitenant
Database?
An application container?
An application root clone gets created automatically.
The upgrade can be performed when connected either to CDB$ROOT or to
PDB$SEED.
After an application upgrade, the application container's PDBs remain
Synchronized with the existing application root.
The upgrade must be performed when connected to CDB$ROOT.
The RESTORE POINT clause?
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
Their recovery in an Oracle Database?
If a row lock is held by a nonexistent transaction, the block containing the row
Is media corrupt.
DB_BLOCK_CHECKING=TRUE causes a check sum to be added to each data
Block to help detect physical or media corruption.
A media corrupt block is one where the block is not formatted correctly.
The ANALYZE TABLE VALIDATE STRUCTURE CASCADE command verifies that
Each table row has an index entry pointing to it.
Multitenant environment?
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.
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.
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.
(TDE)?
Oracle database instance? (Choose three.)
(Choose three.)
(PDB)? (Choose three.)
It is automatically synchronized with its application root PDB when an
Application is upgraded.
It cannot be added to an application container after the application container
Has already been created.
A new application PDB created by cloning an application seed PDB can have
An old version of the application installed after cloning completes.
It is automatically synchronized with its application root PDB when an
Application is installed.
我来回答: