New Year Special 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: Board70

1z0-083 Leak Questions

Page: 6 / 21
Question 24

choose two You configured the Fast Recovery Area (FRA) for your database. The database instance is in ARCHIVELOG mode. The default location for the archived redo log files is the FRA. Which two files are removed automatically if space is required in the FRA as per the retention policy?

Options:

A.

user-managed backups of data files and control files

B.

flashback logs

C.

RMAN backups that are obsolete

D.

archived redo log files that have multiple copies in a different archive location

Question 25

Choose two. In performance management, which two factors might reduce the ability of an application to scale to a larger number of users?

Options:

A.

poorly trained users who do not commit transactions

B.

the number of tablespaces containing tables updated by a transaction

C.

issuing multiple savepoints during a transaction

D.

the number of data files containing extents belonging to tables updated by a transaction

E.

poorly written SQL

Question 26

Which two are true about the Automatic Database Diasnostic Monitor (ADDM)? (Choose two.)

Options:

A.

It analyzes a period of time corresponding to the 12 hours of activity.

B.

It runs automatically after each AWR snapshot.

C.

A DBA can run it manually.

D.

Results are written to the alert log.

E.

It analyzes a period of time corresponding to the last day of activity.

Question 27

Which two are true about Recovery Manager (RMAN) diagnostic message output? (Choose two.)

Options:

A.

Media Management messages for SBT devices are always written to sbtio.log.

B.

RMAN error stacks should be read from the bottom up as that is the order in which errors are generated.

C.

RMAN error stacks should be read from the top down as that is the order in which errors are generated.

D.

The RMAN LOG command line clause causes output issued during RMAN command compilation to be written to a log file and to standard output.

E.

The RMAN LOG command line clause causes output issued during RMAN command compilation to be written to a log file only.

F.

Media Management messages for SBT devices are written to an Oracle trace file.

Page: 6 / 21
Exam Code: 1z0-083
Exam Name: Oracle Database Administration II
Last Update: Dec 22, 2024
Questions: 286
1z0-083 pdf

1z0-083 PDF

$25.5  $84.99
1z0-083 Engine

1z0-083 Testing Engine

$28.5  $94.99
1z0-083 PDF + Engine

1z0-083 PDF + Testing Engine

$40.5  $134.99