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

[不定项选择题]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 Flashback Data Archive?
A. To use Flashback Data Archive, users must have unlimited quota on the
Flashback Data Archive tablespace.
B. To enable Flashback Data Archive for a table, it is mandatory to have a default
Flashback Data Archive for a database.
C. While enabling Flashback Data Archive for a table, if no name is provided for
Flashback Data Archive, it is enabled using the default Flashback Data Archive.
D. A table enabled for Flashback Data Archive cannot be dropped unless
Flashback Data Archive is disabled or disassociated first.
E. Flashback Data Archive prevents flashback queries from getting a
Snapshot-too-old error.

[不定项选择题]Which three statements are true about the keystore storage framework

For transparent data encryption?

A. It facilitates and helps to enforce keystore backup requirements.
B. It handles encrypted data without modifying applications.
C. It enables a keystore to be stored only in a file on a file system.
D. It enables separation of duties between the database administrator and the
Security administrator.
E. It transparently decrypts data for the database users and applications that
Access this data.
F. It helps to track encryption keys and implement requirements such as keystore
Password rotation and master encryption key reset or re-key operations.

[不定项选择题]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 two statements are true when row archival management is
Enabled?
A. The ORA_ARCHIVE_STATE column visibility is controlled by the ROW
ARCHIVAL VISIBILITY session parameter.
B. The ORA_ARCHIVE_STATE column is updated manually or by a program that
Could reference activity tracking columns, to indicate that a row is no longer
Considered active.
C. The ROW ARCHIVAL VISIBILITY session parameter defaults to active rows only.
D. The ORA_ARCHIVE_STATE column is visible if referenced in t he select list of a
Query.
E. The ORA_ARCHIVE_STATE column is updated automatically by the Oracle
Server based on activity tracking columns, to Indicate that a row is no longer
Considered active.

[不定项选择题]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 Lockdown profiles in a container

Database (CDB) and its pluggable databases (PDBs)?

A. A Lockdown profile created from a base Lockdown profile is always
Automatically modified if the profile on which it is based is modified.
B. A PDB Lockdown profile can be created in an application root.
C. A Lockdown profile created from a base Lockdown profile is never
Automatically modified if the profile on which it is based is modified.
D. A PDB Lockdown profile can be created in a regular PDB.
E. A PDB Lockdown profile can be created in CDB$ROOT .

[不定项选择题]Choose two. Which two are true about poorly performing SQL

Statements and their tuning in Oracle database instances?

A. SQL statements performing many physical I/Os can always have their
Performance improved by creating indexes.
B. The solution that best optimizes one SQL statement can degrade the
Performance of others.
C. SQL statements doing joins always do more physical I/O than single table
Queries.
D. Poorly performing SQL statements can be tuned automatically by the Oracle
Server.
E. SQL statements doing only logical reads never require tuning because they do
No physical I/O.

[不定项选择题]Choose two. Which two are true about memory advisors?
A.

If Automatic Memory Management is enabled, no memory advisors are

Available.

B.

If Automatic Memory Management is enabled, the Shared Pool Advisor and

Buffer Cache Advisor are available to set the maximum size for these individual

System Global Area components.

C.

All memory advisors use data from Automatic Workload Repository.

D.

If Automatic Shared Memory Management is enabled, both the SGA Advisor

And PGA Advisor are always available.

E. If Manual Shared Memory Management is enabled, only the Shared Pool
Advisor and Buffer Cache Advisor are available.

[不定项选择题]Choose two. Which two are true about backup encryption?
A. The Transparent Data Encryption (TDE) keystore is backed up using RMAN.
B. Vendor-specific media management software can be used for making
Encrypted RMAN backups to media.
C. The BACKUP BACKUPSET command can encrypt and decrypt backup sets.
D. Image copies can be encrypted.
E. Keystore-based encryption is the default mode for RMAN backup encryption.
F. Backup encryption can be enabled selectively for specific tablespaces.

[不定项选择题]Choose two. Which two are true about various Oracle security and

Auditing capabilities?

A.

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

Be created only if all the PDBs in the application container are closed.

B.

Application-common TSDP policies are always container specific.

C.

Application-common OLS policies can be created only if all the PDBs in the

Application container are closed.

D.

Unified auditing can be automatically synchronized to all application PDBs in

An application container.

E. Fine-grained auditing (FGA) policies in an application root are automatically
Synchronized to all application PDBs contained in the application container when
They are updated.

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

[不定项选择题]Choose two. Which two are true about Optimizer Statistics?
A. They can be gathered by the DBMS_STATS package.
B. They provide real-time data about schema objects.
C. They are gathered by the SQL Tuning Advisor.
D. They are ignored by Optimizer if they are stale.
E. By default, they are automatically gathered by a maintenance job.

[不定项选择题]Choose two. Which two are true about Rapid Home Provisioning of

Oracle software?

A. It can be used for applications and middleware.
B. It can be used only for Oracle Grid Infrastructure, including Oracle Restart.
C. It can be used for both Oracle Database and Oracle Grid Infrastructure,
Including Oracle Restart.
D. It can be used for both Oracle Database and Oracle Grid Infrastructure,
Excluding Oracle Restart.
E. It can be used only for Oracle Grid Infrastructure, excluding Oracle Restart.