Oracle Exam 1Z0-062 Topic 6 Question 4 Discussion

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

Question #: 4
Topic #: 6

Examine the parameters for your database instance:

You execute the following command:

SQL> ALTER TABLESPACE undotbs1 RETENTION NOGUARANTEE;

Which statement is true in this scenario?

AUndo data is written to flashback logs after 1200 seconds.

BInactive undo data is retained for 1200 seconds even if subsequent transactions fail due to lack of space in the undo tablespace.

CYou can perform a Flashback Database operation only within the duration of 1200 seconds.

DAn attempt is made to keep inactive undo for 1200 seconds but transactions may overwrite the undo before that time has elapsed.

Show Suggested Answer

Suggested Answer: D

by Kattie at May 09, 2022, 09:38 AM

Limited Time Offer

25%

Off

Contribute your Thoughts:

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!