[不定项选择题]Which two are true about an Oracle gold image-based installation in

Oracle 18c and later releases?(Choose two.)

A.

It can be used for both Oracle Database and Oracle Grid Infrastructure

Installation.

B.

It can only install and configure Oracle Database software. The database has

To be created separately.

C.

It does not require the setup wizard.

D.

It uses a single RPM that automatically extracts and installs the Oracle

Database software.

E. It can be used to install and upgrade Oracle Database for single-instance and
Cluster configurations.

[不定项选择题]Which two are true about Oracle Optimizer Statistics, their use, and

Their collection? (Choose two.)

A. The number of table rows is considered when evaluating the cost of accessing
A table using an index.
B. Index balanced B*Tree height is considered when evaluating the cost of using
An index.
C. The Statistics Advisor can help recommend the best way to gather statistics.
D. Statistics collected using DBMS_STATS always yield the best optimizer result.
E. The Statistics Advisor generates actions for all recommendations.

[不定项选择题]Which two are true about Oracle Flashback features? (Choose two.)
A. FLASHBACK QUERY can retrieve REDO records from ONLINE and ARCHIVE D
REDO LOG files.
B. FLASHBACK VERSION QUERY can retrieve REDO records from ONLINE and
ARCHIVE D REDO
LOG files.
C. FLASHBACK TABLE can undrop a column.
D. FLASHBACK DROP can undrop an index when undropping a table.
E. After a database is restored from flashback logs using the FLASHBACK
DATABASE command, it is
Sometimes rolled forward using redo logs.

[不定项选择题]Which two are true about diagnosing Oracle Database failure situations

Using Data Recovery Advisor? (Choose two.)

A.

Using the Data Recovery Advisor LIST FAILURE command always requires that

The database for Which failures are to be listed is in MOUNT state.

B.

A failure can be closed only when it has been repaired.

C.

Data Recovery Advisor can be used if a database is closed.

D.

The Data Recovery Advisor CHANGE FAILURE command can be used only to

Change failure priorities.

E. Data Recovery Advisor can proactively check for failures.

[不定项选择题]Which two are true about Oracle instance recovery? 
A.

Recovery begins from the beginning of the CURRENT redo log group.

B.

Recovery begins from the last checkpoint position that was calculated by the

Database Writer before instance failure.

C.

Recovery begins from the start of any ACTIVE redo log group or the start of

The CURRENT log group if no other group is ACTIVE.

D.

Recovery reads redo until the end of the redo thread. SMON rolls back any

Dead transactions, and then the datanase is opened.

E. Recovery begins from the last checkpoint position that was recorded in the
Control file by the checkpoint process (CKPT).
F. Recovery reads redo until the end of the redo thread, and then opens the
Database. SMON then rolls back any dead transactions.

[不定项选择题]Which two are true about Oracle Grid Infrastructure for a Standalone

Server? (Choose two.)

A. It supports volume management, file system, and automatic restart capabilities.
B. It must be installed before the Oracle database software is installed.
C. The CSS daemon runs from the Grid Infrastructure home.
D. It can manage database resources on the server where it is installed or on a
Different server.
E. It requires Oracle Automatic Storage Management (ASM) components to be
Installed separately.

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

(DBCA) templates? (Choose two.)

A. The General Purpose of Transaction Processing templates are most suitable
When concurrency and recoverability are key criteria.
B. Oracle DBCA templates can store only logical structure and not database files.
C. New templates can only be created by modifying an existing user-created
Template.
D. The Data Warehouse template is most suitable when transaction response
Time is the key criterion.
E. Oracle DBCA templates can be used to create new databases and duplicate
Existing databases.

[不定项选择题]Which two are true about the Oracle database methodology? (Choose

Two.)

A.

The Oracle Database time model should be used to find the database and

Instance areas most in need of tuning.

B.

Tuning activities should stop once the user is satisfied with performance.

C.

Tuning activities should stop once agreed service levels for performance have

Been met.

D.

The database instance memory should always be tuned before tuning any file

Systems.

E.

SQL statements should always be tuned before tuning any file systems.

F.

The alert log should be used to find the database and instance areas most in

Need of tuning.

[不定项选择题]Which two are true about the Oracle dataabse methodology? (Choose

Two.)

A.

The Oracle Database time model should be used to find the database and

Instance areas most in need of tuning.

B.

Tuning activities should stop once the user is satisfied with performance.

C.

Tuning activities should stop once agreed service levels for performance have been met.

D.

The database instance memory should always be tuned before tuning any file Systems.

E. SQL statements should always be tuned before tuning any file systems.
F. The alert log should be used to find the database and instance areas most in
Need of tuning.

[不定项选择题]Choose two. Which two are true in Oracle 19c and later releases?
A. Schema Only accounts can be granted administrator privileges.
B. If the password file location changes, then the instance must be restarted.
C. Unified Auditing can be configured to audit only events that are issued directly
By an audited user.
D. All the Oracle-supplied accounts are Schema Only accounts.
E. Unified Auditing can be configured to audit only events that are issued
Indirectly by all users

[不定项选择题]Which three are true about Oracle Grid Infrastructure for a Standalone

Server?

A.

It includes both Oracle Restart and Oracle Automatic Storage Management (ASM) software.

B.

It creates one disk group during installation.

C.

It requires the operating system oracle_base environment variable to be predefined before installation.

D.

It requires Oracle ASM Filter Driver (ASMFD) to manage Automatic Storage Management (ASM) disks

E.

It requires Oracle ASMLibto manage Automatic Storage Management (ASM) disks.

F. Automatic Storage Management (ASM) requires that O/S groups OSASM and
OSDBA be assigned as secondary groups for its installation owner.

[不定项选择题]Which three are true about the Oracle Optimizer? (Choose three.)
A.

It obeys all hints.

B.

It considers the filters in WHERE clauses when generating execution plans for SQL statements.

C.

It can re-optimize execution plans after previous executions detect suboptimal plans.

D.

It considers object statistics when generating execution plans for SQL statements.

E.

It updates stale object statistics in the Data Dictionary.

F.

It can only use SQL plan Directives tied to the SQL statement for which a plan is being generated.

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

And services?

A. V$SERVICE_EVENT displays wait counts for every wait event for each service
Even including counts of zero for waits that never occurred.
B. V$SESSION_WAIT and V$SESSION both contain details of the event on which
A non-waiting session last waited.
C. V$SESSION_WAIT and V$SESSION both contain details of the event on which
A waiting session is currently waiting.
D. V$SESSION_EVENT displays all waits events for those events that have
Occurred at least once for sessions that have now terminated.
E. V$SESSION_WAIT_CLASS displays waits broken down by wait class only for
Terminated sessions.

[不定项选择题]Choose two. Which two are true about server-generated alerts?
A.

Stateless alerts can be cleared manually.

B.

Stateless alerts are automatically cleared after one day.

C.

Stateful alerts are purged automatically from the alert history after one day.

D.

Stateless alerts can be purged manually from the alert history.

E.

Stateful alerts must be cleared by a DBA to resolve the problem identified in the alert.

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