[不定项选择题]Choose three. Which three are true about the FLASHBACK DATABASE

Feature?

A. FLASHBACK DATABASE only uses FLASHBACK LOGS to get the database to
The desired flashback time.
B. It requires that the target database be in ARCHIVELOG mode.
C. FLASHBACK LOGS are archived after a log switch.
D. A database can be flashed back using SQL*PLUS.
E. It always generates REDO and UNDO.
F. Queries and DML have the same FLASHBACK LOG overhead when flashback is
Enabled for a database.

[不定项选择题]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 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 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 using Database Upgrade
Assistant (DBUA) to upgrade a database?
A. DBUA must be launched from the target Oracle Home.
B. Multiple databases with the same ORACLE_HOME can be upgraded
Simultaneously.
C. A whole database backup must exist before upgrade.
D. The Pre-Upgrade Information Tool script is executed by DBUA.
E. All pluggable databases are automatically upgraded as part of a container
Database upgrade.
F. The database must be opened in read-only mode.

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

) It is used in both clustered and non-clustered environments.

B.

) You can add and remove components from an Oracle Restart configuration

With Server Control (SRVCTL) commands.

C.

) It runs from the Oracle Grid Infrastructure home.

D.

) If you shut down a database instance with SQL*Plus, Oracle Restart interprets

This as a database failure and attempts to restart the instance.

E.) The Server Control (SRVCTL) utility can be used to start and stop Oracle
Restart.
F.) It can manage Oracle Database instances, Oracle Net Listeners, and Oracle
Automatic Storage Management instances.

[不定项选择题]Choose three. Which three are true about Automatic Workload Repository

(AWR) and Automatic Database Diagnostic Monitor (ADDM) in an Oracle

Multitenant environment?

A. AWR snapshots can be created in CDB$ROOT.
B. ADDM can run in a nonroot container.
C. AWR reports can be generated while connected to any container.
D. All AWR data is stored in the CDB$ROOT SYSAUX tablespace.
E. AWR snapshots can be created in a PDB.
F. No AWR data is stored in the CDB$ROOT SYSAUX tablespace.

[不定项选择题]Choose three. Which three are true about RMAN archival backups with

The RESTORE POINT clause?

A. They are never considered obsolete by RMAN.
B. They can optionally be written to a fast recovery area (FRA).
C. All archive logs are retained after an archival backup is taken, until the next
Archival backup is taken of the same database.
D. Archive logs are retained if they are necessary to allow the database to be
Recovered to a consistent state when an archival backup is restored.
E. The SPFILE is included in the archival backup.
F. Use of a recovery catalog is always required to support the creation and use of
Archival backups.
G. The ARCHIVAL attribute for a backup overrides the RMAN retention policy.

[不定项选择题]Choose three. Which three are true about recovery operations done
Without using Recovery Manager (RMAN)?
A. A lost PFILE can be re-created from alert.log using SQL*PLUS.
B. A lost index tablespace can be re-created without performing any recovery.
C. A lost password file can be manually re-created with the orapwd utility.
D. A lost password file can be re-created with SQL*PLUS.
E. A lost SPFILE can be recovered from memory using SQL*PLUS.
F. A lost TEMPFILE must always be re-created manually.

[不定项选择题]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 block media recovery?
A. To use it, Flashback Database must be enabled.
B. A block being recovered is not accessible.
C. It cannot repair logical corruption.
D. It can be performed on noncorrupt blocks.
E. The target database for which one or more blocks are to be recovered must be
In the OPEN state.
F. The data file containing the block being recovered remains online.

[不定项选择题]Choose three. Which three are true about Data Pump in an Oracle

Multitenant environment?

A. It can be used to transport data from a non-CDB to a PDB.
B. It can be used to clone a CDB.
C. It can be used to transport data between PDBs.
D. It can be used to transport data from a PDB to a non-CDB.
E. It can be used to create a new PDB.

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

They are installed via OPatch or OPatchAuto.

B.

A base release is not needed to install patchsets.

C.

They can be applied in a rolling fashion for Clusterware and the databases.

D.

Installing a patchset is considered an "upgrade."

E.

They can introduce new features.

F.

They are only released quarterly.