[不定项选择题]choose three. Identify three reasons for using a recovery catalog with

Recovery Manager (RMAN).

A.

to allow database duplication without a connection to the target instance.

B.

to store backup metadata that would cause the controlfile to become too large.

C.

to store backups that would cause the controlfile to become too large.

D.

to report on the database schema at an earlier point in time.

E.

to allow database duplication without a connection to the auxiliary instance.

[不定项选择题]choose three Which three RMAN persistent settings can be set

Explicitly?

A. SPFILE backup duplexing
B. control file auto backup formats
C. archive log deletion policy
D. image copy duplexing
E. redo log backup duplexing
F. archive log backup duplexing

[不定项选择题]Choose three. Which three capabilities require the use of the RMAN

Recovery catalog?

A. using RMAN stored scripts
B. creating encrypted backups
C. creating customized reports about a single database's backups
D. using the REPORT SCHEMA command to list a database's data files and
Tablespaces at times in the past
E. using the KEEP FOREVER clause with the BACKUP command
F. using the REPORT SCHEMA command to list a database's current data files and
Tablespaces

[不定项选择题]choose three Which three are true about Transparent Data Encryption

(TDE)?

A. It uses a single master key for a database.
B. It replaces secure application roles.
C. It encrypts only data on the client.
D. It stores the current and all past master keys in the keystore.
E. Master encryption keys are managed by Oracle Database Vault.
F. It can encrypt data at the column level.

[不定项选择题]choose three Which three are true about RMAN duplexed backup sets or image copies?
A.

A backup set may be duplexed with both copies written to disk.

B.

An image copy on disk can be copied to disk.

C.

A backup set may be duplexed with both copies written to sbt.

D.

A backup set may be duplexed so that one copy is written to sbt and the other

To disk.

E. An image copy on disk can be copied to sbt.
F. An image copy on sbt can be copied to disk.

[不定项选择题]Choose three. Which three resources are always shared among

CDB$ROOT and pluggable databases (PDBs)?

A.

the data dictionary in CDB$ROOT

B.

the log writer process (LGWR)

C.

SYSAUX tablespaces

D.

temporary tablespaces

E. the Process Monitor Process (PMON)
F. undo tablespaces

[不定项选择题]Choose three. Which three are performed by Oracle Automatic
Storage Management (ASM) instances?
A. mounting disk groups
B. acting as an I/O server to read data file blocks from ASM disks on behalf of
Database server processes
C. managing extent allocation for Oracle database segments
D. managing Allocation Units (AUs) for disk group content
E. managing space allocation for Oracle ASM files
F. acting as an I/O server to write data file blocks to ASM disks on behalf of
Database Writer processes (DBWn)

[不定项选择题]Choose three. Which three actions are mandatory post database
Upgrade?
A. Updating client scripts with the new Oracle home.
B. Resetting passwords to enforce case-sensitivity.
C. Run OPatch commands from the new Oracle home.
D. Setting threshold values for tablespace alerts.
E. Migration to unified auditing.
F. Upgrading user tables that depend on Oracle-maintained abstract data types.

[不定项选择题]Choose three. Which three actions will add a resource to an Oracle
Restart configuration?
A. creating a disk group using the CREATE DISKGROUP SQL statement
B. creating a database service using DBMS_SERVICE.CREATE_SERVICE
C. creating a database service using Oracle Database Configuration Assistant
(DBCA)
D. creating a database using the CREATE DATABASE SQL statement
E. creating an Oracle Database service by modifying the SERVICE_NAMES
Parameter
F. creating an Oracle Automatic Storage Management (ASM) instance with ASM
Configuration Assistant (ASMCA)

[不定项选择题]Choose three. Which three activities are possible for PDBs?
A. converting an application seed to an application PDB
B. converting a regular PDB to an application PDB
C. converting an application PDB to an application root
D. copying an application container into another application container in the
Same CDB
E. copying an application container into another application container in a
Different CDB
F. converting an application PDB to an application seed
G. converting an application PDB to a regular PDB

[不定项选择题]Choose three. Which three are true about Rapid Home Provisioning

(RHP), which has been available since Oracle 18c?

A. It can be used to deploy Grid Infrastructure homes, including Oracle Restart.
B. It can be used to deploy Oracle Database homes.
C. It is an Oracle Database service.
D. It cannot be used to provision applications.
E. It cannot be used to provision middleware.
F. It is an Oracle Grid Infrastructure service.

[不定项选择题]Choose three. Which three are true about Audit policies in container
Databases (CDBs)?
A. All audit records are written to the audit trail in CDB$ROOT .
B. Application-common unified audit policies defined in an application root must
Be manually synchronized by each application PDB contained in the application
Root.
C. Fine-grained auditing policies defined in an application root must be manually
Synchronized by each application PDB contained in the application root.
D. A common unified audit policy can be created at the CDB level.
E. A common unified audit policy can be created at the application root level.
F. An application PDB cannot have a local audit policy.

[不定项选择题]Choose three.

Which three are true about interpreting Recovery Manager (RMAN) error

Stacks returned to standard output?

A.

If an RMAN command fails, the output will only identify the command that

Failed.

B.

Some messages in the error stack are not errors.

C.

If an RMAN command fails, the output will identify the channel ID where the

Failure occurred.

D.

Media Management errors appear as a line with "Additional information" and

A number.

E. Media Management errors appear as a line with "sbtio" and a number.
F. Media Management errors appear as a line with "sbtio".

[不定项选择题]Choose three.

Which three are true about SGA memory management in a multitenant

Database?

A. SGA_MIN_SIZE cannot be set for a PDB.
B. Setting SHARED_POOL_SIZE for a PDB guarantees a minimum amount of
Shared Pool memory for that PDB.
C. Setting SGA_TARGET for a PDB guarantees a minimum amount of SGA
Memory for that PDB.
D. The SHARED_POOL_SIZE setting for a PDB can be up to 80% of the
SHARED_POOL_SIZE setting of the root container.
E. Setting DB_CACHE_SIZE for a PDB guarantees a minimum amount of Database
Buffer Cache memory for that PDB.
F. The SGA_TARGET setting for a PDB cannot exceed 50% of the SGA_TARGET
Value of the root container.

[不定项选择题]Choose three. Which three are true about the Oracle Optimizer?
A.

It considers the filters in WHERE clauses when generating execution plans for SQL statements.

B.

It obeys all hints.

C.

It considers object statistics when generating execution plans for SQL statements.

D.

It updates stale object statistics in the Data Dictionary.

E. It can only use SQL Plan Directives tied to the SQL statement for which a plan
Is being generated.
F.

It can re-optimize execution plans after previous executions detect suboptimal plans.

[不定项选择题]Choose three. Which three are true about post-upgrade activities

When upgrading an Oracle database using Database Upgrade Assistant?

A.

Any Recovery Manager (RMAN) recovery catalog must be upgraded manually.

B.

After a manual upgrade, TNSNAMES.ORA entries must be updated to reflect

The new ORACLE_HOME.

C.

Time zone files must be upgraded manually using the DBMS_DST PL/SQL

Package.

D.

The new extended data type capability must be enabled by running the

Utlrp.sql script

E. The Oracle Application Express configuration should be updated after
Upgrading Oracle Database.

[不定项选择题]Choose three. Which three are true about corrupted data blocks and

Their recovery in an Oracle Database?

A.

If a row lock is held by a nonexistent transaction, the block containing the row

Is media corrupt.

B.

DB_BLOCK_CHECKING=TRUE causes a check sum to be added to each data

Block to help detect physical or media corruption.

C.

A media corrupt block is one where the block is not formatted correctly.

D.

The ANALYZE TABLE VALIDATE STRUCTURE CASCADE command verifies that

Each table row has an index entry pointing to it.

E. If a row lock is held by a nonexistent transaction, the block containing the row
Is logically corrupt.
F. DB_LOST_WRITE_PROTECT=TYPICAL causes extra logging overhead on the
Standby database.

[不定项选择题]Choose three. Which three are true about upgrading an application in

An application container?

A.

An application root clone gets created automatically.

B.

The upgrade can be performed when connected either to CDB$ROOT or to

PDB$SEED.

C.

After an application upgrade, the application container's PDBs remain

Synchronized with the existing application root.

D.

The upgrade must be performed when connected to CDB$ROOT.

E. An application name and version number must be specified to upgrade the
Application.
F. After an application upgrade, the application container's PDBs are
Automatically synchronized with the application root clone.