Exam 1z0-052 topic 3 question 142 discussion

Actual exam question from Oracle's 1z0-052

Question #: 142
Topic #: 3

Examine these SQL statements and their output:

Which two are true? (Choose two.)

A. Transactions will wait until free space becomes available in the UNDO tablespace when they have failed to allocate space
B. Inactive UNDO will be retained for at least 15 minutes
C. Active UNDO will be retained as long as needed by the transactions
D. Expired UNDO will be retained as long as possible within the limits of the current size of the UNDO tablespace
E. The UNDO tablespace will grow automatically if there is not enough space to retain active UNDO

Show Suggested Answer

Suggested Answer: AC 🗳️

by giovi411 at June 20, 2019, 10:13 a.m.

Submit Cancel

5 years, 5 months ago

Inactive undo will be retain for at least 15 minutes + Active undo will be retained as long as needed by the transactions

upvoted 2 times

...

Most Voted

Loading ...