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

Oracle Database 19c 1z0-083 Reddit Questions

Page: 2 / 21
Total 286 questions

Oracle Database Administration II Questions and Answers

Question 5

Choose two. Your database is in ARCHIVELOG mode and you plan to use Flashback Database. Which two features or parameters manage space availability in the fast recovery area?

Options:

A.

the backup retention policy

B.

the backup optimization policy

C.

the DB_CREATE_ONLINE_LOG_DEST_n parameter setting

D.

the archived log deletion policy

E.

the DB_RECOVERY_FILE_DEST parameter setting

F.

using guaranteed UNDO retention

Question 6

Which three are true about thresholds, metrics, and server-generated alerts? (Choose three.)

Options:

A.

All metrics are instance related.

B.

Cleared stateful alerts are displayed by querying DBA_ALERT_HISTORY.

C.

A space usage management alert is automatically cleared after the underlying problem is resolved

D.

They are generated by SMON when a tablespace is 97% full.

E.

Metrics are statistical counts for a specific unit.

F.

STATISTICS_LEVEL must be set to ALL to generate alerts.

Question 7

Choose two. Which two are true about a Recovery Manager (RMAN) duplication without a TARGET connection?

Options:

A.

The UNDO TABLESPACE clause is always required when no connection exists to the recovery catalog and the TARGET database is closed.

B.

RMAN disk-based backups of the database to be duplicated can be used by the auxiliary instance.

C.

The UNDO TABLESPACE clause is always required when no connection exists to the TARGET instance.

D.

The UNDO TABLESPACE clause is never required.

E.

RMAN "pushes" the backups of the database to be duplicated over the network to the auxiliary instance.

Question 8

Choose three. Which three capabilities require the use of the RMAN recovery catalog?

Options:

A.

using RMAN stored scripts

B.

creating encrypted backups

C.

creating customized reports about a single database's backups

D.

using the REPORT SCHEMA command to list a database's data files and tablespaces at times in the past

E.

using the KEEP FOREVER clause with the BACKUP command

F.

using the REPORT SCHEMA command to list a database's current data files and tablespaces

Page: 2 / 21
Total 286 questions