Labour Day Special - Limited Time 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: top65certs

1z0-083 Leak Questions

Page: 6 / 21
Total 286 questions

Oracle Database Administration II Questions and Answers

Question 21

Which three are located by using environment variables?

Options:

A.

the Optimal Flexible Architecture (OFA) compliant path to store Oracle software and configuration files.

B.

the location of Oracle Net Services configuration files

C.

the list of a disk group names to be mounted by an Oracle Automatic Storage Management (ASM) instance at startup

D.

default directories for temporary files used by temporary tablespaces

E.

the temporary disk space used by Oracle Installer during installation

F.

the maximum number of database files that can be opened by a database instance

Question 22

Which two arc true about Optimizer Statistics ?

Options:

A.

They can be gathered by the DBMS_STATE package.

B.

They are ignored by Optimizer if they are state.

C.

They are gathered by the SQL Tuning Advisor.

D.

By default, they are automatically gathered by a maintenance job.

E.

They provide real-time data about schema objects.

Question 23

Which three are true about RMAN persistent configuration settings, administration, and their effects? (Choose three.)

Options:

A.

A target database’s persistent RMAN configuration settings are always stored in the target’s control file

B.

Backup older than the recovery window retention policy are always deleted automatically if the backup location has insufficient space.

C.

Backups written to the fast recovery area (FRA) that are oboslete based on the redundancy retention policy can be deleted automatically to free space.

D.

The RMAN SHOW ALL command displays only settings with nondefault values.

E.

A target database’s persistent RMAN configuration settings are always synchronized automatically with the RMAN catalog.

F.

The V$RMAN_CONFIGURATION view displays only settings with valuesthat have been modified. G)A DBA must specify either a redundancy retention policy or a recovery window retention policy.

Question 24

Which two are true about instance recovery? (Choose two.)

Options:

A.

It is not possible if an archived log is missing.

B.

It is performed automatically after the database is opened; however, blocks requiring recovery are not available until they are recovered.

C.

Setting FAST_START_MTTR_TARGET to a lower value reduces instance recovery time by causing dirty buffers to be written to disk more frequently, thereby reducing the number of I/Os needed during instance recovery.

D.

It is performed by the Recovery Writer (RVWR) background process.

E.

Setting FAST_START_MTTR_TARGET to a higher value reduces instance recovery time by causing The log writer to write more frquently, thereby reducing the number of I/Os needed during instance recovery.

F.

It is performed automatically while the database remains in MOUNT state. Then the database is opened.

Page: 6 / 21
Total 286 questions