[不定项选择题]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 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 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 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 creating container databases (CDBs) and

Pluggable databases (PDBs) in Oracle 19c and later releases?

A.

A snapshot copy PDB can be a full copy of a source PDB.

B.

A snapshot copy PDB does not depend on an existing storage snapshot of the

Source PDB.

C.

A PDB snapshot depends on an existing storage snapshot of the source PDB.

D.

A PDB snapshot can be a full copy of a source PDB.

E. A CDB can be duplicated using the Database Configuration Assistant (DBCA) in
Silent mode with no configuration required before starting the duplication.
F. A CDB can be duplicated using Recovery Manager (RMAN) with no
Configuration required before starting the duplication.
G. A PDB snapshot can be a sparse copy of a source PDB.

[不定项选择题]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 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 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 OPatch ?
A. It requires installation of Oracle Universal Installer.
B. It supports Rolling Patching.
C. It must be invoked as the user that owns the software being patched.
D. It is a Java-based utility for applying patchsets.
E. It is platform independent.
F. It can be used to apply interim patches to the Grid Infrastructure and Database
Home combination.

[不定项选择题]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 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 a whole database backup?
A. It can be created only by using RMAN.
B. It always includes all data files, the current control file, the server parameter file,
And archived redo logs.
C. It can be consistent.
D. It is the only possible backup type for a database in NOARCHIVELOG mode.
E. It can consist of either backup sets or image copies.
F. It can be inconsistent.

[不定项选择题]Choose three.

Which three are true about actions that can or cannot be performed by users

With the SYSBACKUP privilege?

A.

They can view data from any data dictionary view or dynamic performance

View.

B.

They can drop any tablespace.

C.

They can view data from any user-defined tables.

D.

They can create any table.

E.

They cannot create restore points.

F.

They cannot drop tablespaces.

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