[不定项选择题]Which three are true? ()
A.

Virtual Private Database (VPD) policies on objects in an application root are

Automatically synchronized with all application PDBs contained in the application

Container.

B.

Application-common TSDP policies are always container specific.

C.

Application-common Transparent Security Data Protection (TSDP) policies can

Be created only within an application install/patch BEGIN-END block.

D.

Application-common Oracle Label Security (OLS) policies cannot be created in

An application root outside an install/patch BEGIN-END block.

E. Fine-grained auditing (FGA) policies in an application root are automatically
Synchronized to all application PDBs contained in the application container.
F. Application-common OLS policies can be created in an application root inside
An install/patch BEGINEND block.
G. Unified auditing can be automatically synchronized to all application PDBs in
An application container.

[不定项选择题]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 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 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 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 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 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 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 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 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 in Oracle 19c and later releases?
A.

Tablespaces always remain in read/write mode during transportable

Tablespace operations.

B.

Tablespaces never remain in read/write mode during transportable tablespace

Operations.

C.

A transportable data pump import can leave a plugged-in tablespace in

Read-only mode.

D.

Simultaneous data pump jobs can be limited at the pluggable database (PDB)

Level.

E. A transportable data pump import can leave a plugged-in tablespace in
Read/write mode.
F. An ordinary data pump export of a table with encrypted columns will always
Encrypt the same columns when imported.

[不定项选择题]Choose three. Which three are true about cloning databases into an

Existing CDB with RMAN?

A. A non-CDB can be cloned into a PDB.
B. A user with SYSDBA or SYSBKUP must be logged in with RMAN to CDB$ROOT
When cloning a PDB.
C. Only one PDB can be cloned at a time.
D. Two or more PDBs can be cloned with the same command.
E. A user with SYSDBA or SYSBKUP must be logged in with RMAN to the
Non-CDB being cloned when cloning a non-CDB.
F. The target and auxiliary instance passwords must be the same.

[不定项选择题]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 an application container?
A. It must have an application root PDB.
B. Two application containers can share an application seed PDB.
C. It can contain multiple applications.
D. It can contain a single application.
E. It must have an application seed PDB.
F. An application PDB can belong to multiple application containers.

[不定项选择题]Choose three. Which three are true about the tools for diagnosing
Oracle Database failure situations?
A. RMAN can always repair corrupt blocks.
B. Flashback commands help with repairing physical errors.
C. The ADR can store metadata in an Oracle Database repository.
D. The Automatic Diagnostic Repository (ADR) has a separate home directory for
Each instance of each Oracle product that is installed and uses it.
E. The ADR command-line utility (ADRCI) can package incident information to
Send to Oracle Support.
F. The Data Recovery Advisor uses the ADR.