Oracle Exam 1Z0-083 Topic 1 Question 79 Discussion

Actual exam question for Oracle's 1Z0-083 exam

Question #: 79
Topic #: 1

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

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

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

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

DFlashback 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.

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

Show Suggested Answer

Suggested Answer: B, C

by Cammy at Sep 01, 2023, 06:43 PM

Limited Time Offer

25%

Off

Get Premium 1Z0-083 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Levi

29 days ago

Flashback logs are so important, but they can also take up a ton of space. Oracle should just hire a team of flashback log janitors to keep everything tidy. Problem solved!

upvoted 0 times

...

Evan

30 days ago

Option E is a bold choice - automatically purging flashback logs whenever the retention target changes? That sounds like a recipe for disaster!

upvoted 0 times

Sage

12 days ago

Option E does sound risky, but it could also help manage space efficiently.

upvoted 0 times

...

William

18 days ago

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.

upvoted 0 times

...

Myong

21 days ago

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

upvoted 0 times

...

Veta

1 months ago

This is a tricky one, but I think A and C are the correct answers. Automatic purging is important, but it should be done proactively.

upvoted 0 times

...

Blair

1 months ago

D sounds interesting, but I'm not sure if it's the best approach. Leaving manual purging to an administrator-written trigger could be risky.

upvoted 0 times

Floyd

9 days ago

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

upvoted 0 times

...

Hyun

13 days ago

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

upvoted 0 times

...

Raelene

14 days ago

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.

upvoted 0 times

...