[不定项选择题]Which two statements are true about RMAN duplexed backups?
A. It is not supported for image copies.
B. It is only supported for backups to tape via the media management interface.
C. Duplex backups can be performed on either disk or media, but cannot be
Performed on media and disk simultaneously.
D. Duplex backups can contain only data files and control files.
E. For performing duplexed backups, the parallelism for the device must be set
Equal to the number of copies.

[不定项选择题]Which two statements are true about Resource Manager plans for

Individual pluggable databases (PDB plans) in a multitenant container

Database (CDB)?

A. If no PDB plan is enabled for a pluggable database, then all sessions for that
PDB are treated to an equal degree of the resource share of that PDB.
B. In a PDB plan, subplans may be used with up to eight consumer groups.
C. If a PDB plan is enabled for a pluggable database, then resources are allocated
To consumer groups across all PDBs in the CDB.
D. If no PDB plan is enabled for a pluggable database, then the PDB share in the
CDB plan is dynamically calculated.
E. If a PDB plan is enabled for a pluggable database, then resources are allocated
To consumer groups based on the shares provided to the PDB in the CDB plan
And the shares provided to the consumer groups in the PDB plan.

[不定项选择题]Which two statements are true about recovering logically corrupted

Tables or table partitions from an RMAN backup?

A. Tables or table partitions can be recovered by using an auxiliary instance only.
B. Tables or table partitions with a foreign key cannot be recovered.
C. Tables or table partitions can be recovered only when the database is in
Mount state.
D. Tables or table partitions from the system and sysaux tablespaces cannot be
Recovered.
E. Tables with not null constraints cannot be recovered.

[不定项选择题]Which two statements are true about the Database Configuration

Assistant (DBCA)?

A. It can configure Automatic Storage Management (ASM) diskgroups.
B. It can be used to copy an existing Oracle database to a new host and apply
Any patches necessary in the new host.
C. It can be used to add a new tablespace.
D. It can be used to create a database template from an existing database.
E. It can generate SQL database creation scripts.

[不定项选择题]Which two are true about creating RMAN backups for an Oracle

Container database?

A. Online Redo Log backups can be created while connected to CDB$ROOT
B. Control file backups can be created while connected to CDB$ROOT.
C. The BACKUP TABLESPACE command can back up a pDB tablespace even if
RMAN is connected to CDB$ROOT.
D. Archived Redo Log backups can be created while connected to PDB
E. Control file backups can not be created while connected to a PDB

[不定项选择题]choose two Which two are true about RMAN image copies?
A.

) They can only be written to disk.

B.

) They can be encrypted using Transparent Data Encryption (TDE).

C.

) They can be used as a level 0 incremental backup.

D.

) They can be used as a level 1 incremental backup.

E.) They are the only backup option available for databases in NOARCHIVELOG
Mode.

[不定项选择题]Choose two. Which two are true about RMAN persistent configuration

Settings, administration, and their effects?

A. A DBA must specify either a redundancy retention policy or a recovery window
Retention policy.
B. A target database's persistent RMAN configuration settings are always
Synchronized automatically with the RMAN catalog.
C. Backups older than the recovery window retention policy are always deleted
Automatically if the backup location has insufficient space.
D. Backups written to the fast recovery area (FRA) that are obsolete based on the
Redundancy retention policy can be deleted automatically to free space.
E. A target database's persistent RMAN configuration settings are always stored
In the target's control file

[不定项选择题]Which two are true about RMAN Multisection backups when a very

Large data file is divided into four sections? (Choose two.)

A. Each of the file sections must be processed serially.
B. The four sections can be created serially.
C. The four sections must be image copies.
D. The four sections can be created in parallel.
E. The four sections must be contained in backup sets.

[不定项选择题]Choose two.

Which two are true about RMAN virtual private catalogs (VPCs)?

A.

The RMAN catalog owner can grant access for an already registered database

To a new virtual catalog owner.

B.

Each VPC is owned by the recovery catalog schema owner.

C.

RMAN uses Oracle Virtual Private Database (VPD) to implement VPCs.

D.

Only one target database can be registered in a VPC.

E.

VPC functionality is enabled by default.

[不定项选择题]Which two are true about RMAN backups when using a media manager

To write backups to tape when there are only two tape drives? (Choose two.)

A.

SBT tape compression can be used even if no RMAN compression is configured.

B.

Any backup set written to the SBT device in this configuration can contain a

Maximum of two backup pieces.

C.

Any backup written to the SBT device in this configuration can contain a

Maximum of two backup sets.

D.

SBT tape compression and RMAN backup compression should be used in Parallel.

E.

The SBT device should be configured to use PARALLELISM 2 to allow both tape drive to be used simultaneously.

[不定项选择题]Which two are true about RMAN duplexed backup sets? (Choose two.)
A. A duplexed backup set uses the same number of SBT channels as a
Non-duplexed backup set for the same number of files.
B. A non-duplexed backup set written to disk can be duplexed to disk by backing
Up the backup set that is already on disk.
C. A non-duplexed backup set written to SBT can be duplexed to tape by
Backing up the backup set that is already on tape.
D. A non-duplexed backup set written to disk can be duplexed to tape by
Backing up the backup set that is already on disk.
E. A non-duplexed backup set written to SBT can be duplexed to disk by backing
Up the backup set that is already on tape.
F. A duplexed backup set always uses twice as many SBT channels as a
Non-duplexed backup set for the same number of files.

[不定项选择题]Which two are true about RMAN encryption? (Choose two.)
A.

RMAN encryption keys are stored in a database keystore.

B.

RMAN can encrypt the Oracle Database password file.

C.

Dual-mode encrypted backups can be restored only if both the password and

The keystore used for encryption are available.

D.

The SET ENCRYPTION command overrides encryption settings specified by

The CONFIGURE ENCRYPTION command.

E. Password encryption can be persistently configured using the CONFIGURE
ENCRYPTION command.

[不定项选择题]choose two Which two statements are true about encrypted backups

Performed by using RMAN?

A. Transparent encryption of backups uses an encryption wallet.
B. Image copy backups can be created by using password encryption.
C. A password encryption of backups uses the password while creating and
Restoring backups.
D. Encrypted backups can only be written to disk.
E. A database uses the same encryption key for every encrypted backup.

[不定项选择题]Choose two.

Which two statements are true when row-archival management is enabled?

A.

The ORA_ARCHIVE_STATE column may only be queried by users with the DBA

Role set.

B.

The ORA_ARCHIVE_STATE column is only displayed if it is referenced in the

Column select list of a query

C.

The ROW ARCHIVAL VISIBILITY session parameter defaults to active rows.

D.

The ORA_ARCHIVE_STATE column may only be updated by users with the

DBA role set.

E. The ORA_ARCHIVE_STATE column is updated in an overnight maintenance job
Based on activity tracking.

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