[不定项选择题]Which three are true about upgrading Oracle Grid Infrastructure?

(Choose three.)

A.

A direct upgrade can be performed only from the immediately preceding

Oracle Grid Infrastructure version.

B.

The newer version is installed in a separate Oracle Grid Infrastructure home on

The same server as the existing version.

C.

An existing Oracle base can be used.

D.

The upgrade process will automatically install all mandatory patches for the

Current version of Oracle Grid Infrastructure.

E. Existing Oracle Database instances must be shut down before starting the
Upgrade.
F. Only the grid user can perform the upgrade.

[不定项选择题]Choose two. Which two are true about Oracle Database Configuration

Assistant (DBCA)?

A. It can only be launched from the command line interface.
B. It can be launched from both the command line and the Universal Installer
(OUI) interfaces.
C. It can be used to create container databases and non-container databases.
D. It can be used to change the character set of an existing database.
E. It can be used to convert a non-container database to a container database.

[不定项选择题]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.

[不定项选择题]Which three statements are true about Automatic Workload

Repository (AWR)?

A.

All AWR tables belong to the SYSTEM schema.

B.

The AWR data is stored in memory and in the database.

C.

The snapshots collected by AWR are used by the self-tuning components in the database

D.

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.

E. AWR contains system wide tracing and logging information.

[不定项选择题]Which three statements are true about Flashback Database?
A.

Flashback logs are written sequentially, and are archived.

B.

Flashback Database uses a restored control file to recover a database.

C.

The Oracle database automatically creates, deletes, and resides flashback logs

In the Fast Recovery Area.

D.

Flashback Database can recover a database to the state that it was in before a

Reset logs operation.

E. Flashback Database can recover a data file that was dropped during the span
Of time of the flashback.
F. Flashback logs are used to restore to the blocks' before images, and then the
Redo data may be used to roll forward to the desired flashback time.

[不定项选择题]Choose three. Which three are true about using an RMAN Recovery

Catalog with a pluggable database (PDB) target connection in Oracle

Database 19c and later releases?

A.

The base catalog owner must give the Virtual Private Catalog access to

Metadata for one or more PDBs.

B.

The target PDB must be registered in both the base catalog and the Virtual Private Catalog.

C.

The base catalog must be used by RMAN when performing point-in-time

Recovery for the PDB registered in the Virtual Private Catalog.

D.

The base catalog must be enabled for Virtual Private Catalog use.

E. The target PDB must be registered in a Virtual Private Catalog.
F. The target PDB must be registered in a base catalog.

[不定项选择题]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.

[不定项选择题]Choose three. Which three are true about Recovery Manager (RMAN)

Active database duplication?

A. Pre-existing backups of the database to be duplicated are required for the
"push" method of duplication.
B. Pre-existing backups of the database to be duplicated are required for the
"pull" method of duplication.
C. Pre-existing backups of the database to be duplicated are always used if they
Exist.
D. Image copies can be used to duplicate the active database.
E. The active database must be duplicated while in OPEN state.
F. No connection to the recovery catalog is required for active database
Duplication.
G. Backup sets can be used to duplicate the active database.

[不定项选择题]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 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 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 recovering tables using

RMAN?

A.

RMAN can recover tables owned by the SYSTEM user.

B.

RMAN can recover tables owned by the SYS user.

C.

RMAN can recover tables in the SYSTEM tablespace.

D.

RMAN always uses an auxiliary instance.

E. RMAN can recover a table after a DDL operation has altered the table
Structure.
F. RMAN can recover tables in the SYSAUX tablespace.
G. RMAN can recover tables in a standby database.

[不定项选择题]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.