# 1z0-062 — Question 602

**Type:** multiple_choice
**Topics:** topic_1

## Question

Examine the parameters for your database instance:
//IMG//

You execute the following command:
SQL> ALTER TABLESPACE undotbs1 RETENTION NOGUARANTEE;
Which statement is true in this scenario?

## Correct Answer

_See scenario._

## Explanation

B -> if RETENTION GRANTEE, it will let lack of space in the undo tablespace
D -> NOGUARANTEE -> it won't have lack of space so it may overwrite
THe answer is D

**Reference:** examtopics_top_comment

---
Source: https://hiexam.net/q/oracle/1z0-062/602  
Practice (tracked): https://hiexam.net/study/1z0-062/practice