Create Next App

Exam contains 181 questions

Page 5 of 31

Question 25 🔥

Which two are true about flashback features in Oracle Database 19c and later releases? (Choose two.)

Which database solution meets these requirements?

A. Flashback logs are automatically purged when DB_FLASHBACK_RETENTION_TARGET is set lower than the time they have already been retained.

Highly voted

B. Flashback logs are monitored and proactively deleted when beyond the retention period defined in DB_FLASHBACK_RETENTION_TARGET only after there is space pressure.

Highly voted

C. Flashback logs are monitored and proactively deleted when beyond the retention period defined in DB_FLASHBACK_RETENTION_TARGET before there is space pressure.

Highly voted

D. Flashback logs are monitored for being older than the retention period defined in DB_FLASHBACK_RETENTION_TARGET and can be deleted by an administrator written event trigger.

Highly voted

E. Flashback logs are automatically purged whenever the value of DB_FLASHBACK_RETENTION_TARGET is changed.

Highly voted

Discussion of the question

Question 26 🔥

Examine these queries and their output:After a system crash, an instance restart and an attempted opening of the PDBs result in:Which two are true? (Choose two.)

Which database solution meets these requirements?

A. Data file 24 can be recovered while PDB2 is opened.

Highly voted

B. Data file 24 must be recovered while the CDB is opened.

Highly voted

C. Data file 24 can be recovered while CDB$ROOT and PDB$SEED are opened.

Highly voted

D. Data file 24 cannot be recovered while the CDB is opened.

Highly voted

E. Data file 24 must be recovered while PDB2 is closed.

Highly voted

Discussion of the question

Question 27 🔥

Which two are true about RMAN duplexed backup sets? (Choose two.)

Which database solution meets these requirements?

A. A duplexed backup set uses the same number of SBT channels as a non-duplexed backup set for the same number of files.

Highly voted

B. A non-duplexed backup set written to disk can be duplexed to disk by backing up the backup set that is already on disk.

Highly voted

C. A non-duplexed backup set written to SBT can be duplexed to tape by backing up the backup set that is already on tape.

Highly voted

D. A non-duplexed backup set written to disk can be duplexed to tape by backing up the backup set that is already on disk.

Highly voted

E. A non-duplexed backup set written to SBT can be duplexed to disk by backing up the backup set that is already on tape.

Highly voted

F. A duplexed backup set always uses twice as many SBT channels as a non-duplexed backup set for the same number of files.

Highly voted

Discussion of the question

Question 28 🔥

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

Which database solution meets these requirements?

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

Highly voted

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

Highly voted

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

Highly voted

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

Highly voted

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

Highly voted

F. The V$RMAN_CONFIGURATION view displays only settings with values that have been modified.

Highly voted

G. A DBA must specify either a redundancy retention policy or a recovery window retention policy.

Highly voted

Discussion of the question

Question 29 🔥

Which three are true about Optimizer Statistics Advisor? (Choose three.)

Which database solution meets these requirements?

A. It can be run only manually.

Highly voted

B. It is part of the DBMS_ADVISOR package.

Highly voted

C. It can recommend changes to improve the statistics gathering process.

Highly voted

D. It always analyzes all schemas in the database.

Highly voted

E. It runs automatically every night by default.

Highly voted

F. It is part of the DBMS_STATS package.

Highly voted

Discussion of the question

Question 30 🔥

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

Which database solution meets these requirements?

A. All metrics are instance related.

Highly voted

B. Cleared stateful alerts are displayed by querying DBA_ALERT_HISTORY.

Highly voted

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

Highly voted

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

Highly voted

E. Metrics are statistical counts for a specific unit.

Highly voted

F. STATISTICS_LEVEL must be set to ALL to generate alerts.

Highly voted

Discussion of the question

Ready to Pass Your Certification Test

oracle 1Z0_083

Exam contains 181 questions

Lorem ipsum dolor sit amet consectetur. Eget sed turpis aenean sit aenean. Integer at nam ullamcorper a.

Company

Product

Resources

Follow us