[不定项选择题]Choose two.

You want to install Oracle Grid Infrastructure for a Standalone Server using

Oracle Universal Installer (OUI).

There is no existing Oracle installation on the server.

Which two are prerequisites?

A.

an operating system user to own this installation

B.

the Oracle Inventory group oinstall

C.

an operating system account called grid

D.

a group called dba

E.

the installation of Oracle ASMLIB

[不定项选择题]You plan to install Oracle Grid Infrastructure for a Standalone Server

And Oracle Database for the first time on a server.

Examine this command and its outcome:

Which two are true? (Choose two.)

A.

oracle will be an owner of the Oracle Inventory.

B.

oracle must be the owner of every Oracle Database installation.

C.

oracle can own an Oracle Database installation but not an Oracle Grid

Infrastructure installation.

D.

oracle will be granted the SYSASM privilege when installing the Oracle

Database software.

E. The user account, oracle, and group, oinstall, can be used for all Oracle
Software installations.

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

[不定项选择题]After implementing full Oracle Data Redaction, you change the default

Value for the NUMBER data type as follows:

SQL> select number_value from REDACTION_VALUES_FOR_TYPE_FULL;

NUMBER_VALUE

------------

0

SQL> exec DBMS_REDACT.UPDATE_FULL_REDACTION_VALUES(-1);

SQL> select number_value from REDACTION_VALUES_FOR_TYPE_FULL;

NUMBER_VALUE

------------

-1

After changing the value, you notice that FULL redaction continues to redact

Numeric data with zero.（您注意到 FULL 编校继续以零编校数值数据）也就是

上面的修改还没有生效，该命令是把 number 的数据类型编辑以后默认值为－1）。

What must you do to activate the new default value for numeric full

Redaction?

A.

Re-enable redaction policies that use FULL data redaction.

B.

Re-create redaction policies that use FULL data redaction.

C.

Re-connect the sessions that access objects with redaction policies defined on

Them.

D.

Flush t he shared pool.

E. Restart the database instance.

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

[不定项选择题]While backing up to the Oracle Fast Recovery Area (FRA), you

Determined the backup istaking too long and suspect a performance

Bottleneck. Which three are true about diagnosing and tuning these

Problems? (Choose three.)

A. If an RMAN BACKUP VALIDATE command takesroughly the same time as an
Actual backup, then both read and write I/O are likely bottlenecks.
B. Setting DBWR_IO_SLAVES to a non zero value can improve backup
Performance when using synchronous I/O.
C. If an RMAN BACKUP VALIDATE command takes noticeably lessthan an actual
Backup, then write I/O is a likely bottleneck.
D. If an RMAN BACKUP VALIDATE command takesroughly the same time as an
Actual backup, then read I/O is a likely bottleneck.
E. Data files with a high value in
V$BACKUP_SYNC_IO.DISCRETE_BYTES_PER_SECOND are a potential
Performance bottleneck when synchronous I/O is used.
F. Setting DBWR_IO_SLAVES to a non zero value can improve backup
Performance when using asynchronous I/O/
G. Data files with a high value in V$BACKUP_ASYNC_IO.SHORT_WAITS are a
Potential performance bottleneck when asynchronous I/O is used.

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

[不定项选择题]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 three can be done using Oracle Database Configuration Assistant

(DBCA) starting from Oracle Database 19c? (Choose three.)

A. cloning a remote container database in interactive mode
B. cloning a remote pluggable database in silent mode
C. relocating a remote pluggable database in interactive mode
D. relocating a remote container database in silent mode
E. cloning a remote container database in silent mode
F. relocating a remote pluggable database in silent mode
G. relocating a remote container database in interactive mode

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

[不定项选择题]You are working on an Oracle Database 19c database. You enabled the

Flashback Database feature. Which two statements regarding flashback logs

Are true? (Choose two.)

A. Flashback logs are not archived.
B. Flashback logs are maintained in redo log files.
C. Flashback logs are maintained in the Flash Recovery Area.
D. Flashback logs are used to maintain Flashback Database related errors.
E. Flashback logs need to be cleared manually after you disable Flashback
Database.

[不定项选择题]The CATDB12c database contains an Oracle Database version 12c

Catalog schema owned by the RC12C user. The RCAT11 database contains an

Oracle Database version 11g catalog schema owned by the RC11 user in

Which several databases are registered. Both the databases are open. You

Execute the RMAN commands:

RMAN> CONNECT CATALOG rcl2c/passl2c@catdbl2c

RMAN> IMPORT CATALOG rcll/pwdcatll@ractll

Which two tasks are performed as part of the import?

A. Databases from the RC12C catalog are implicitly unregistered if the RC11
Catalog has registered databases with same name.
B. Recovery catalog is resynchronized with the control files of the registered
Databases.
C. Imported databases are unregistered from the RC11 catalog.
D. Local and global stored scripts that have the same name as existing scripts in
The RC12C catalog are automatically renamed.
E. All databases registered in the RC11 catalog are registered in the RC12C
Catalog.

[不定项选择题]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 three are true in Oracle 19c and later releases? (Choose three.)
A. If the password file location changes, then the new location is used
Automatically by the Oracle Server.
B. Schema Only accounts can be granted administrator privileges.
C. All the Oracle-supplied accounts are Schema Only accounts.
D. Privilege Analysis is included in Oracle Enterprise Edition and no longer
Requires Database Vault.
E. Unified Auditing can be configured to audit only events that are issued
Indirectly by an audited user.
F. Unified Auditing can be configured to audit only events that are issued directly
By an audited user.