OCP考试052考题：1Z0-V8.02-第30题

OCP考试052考题：1Z0-V8.02-第30题，完整题库请点击这里联系老师咨询了解

30. In which situation may the UNDO_RETENTION parameter be ignored, even if it is set to a value?

A.when the data file of the undo tablespace is autoextensible

B.when there are more than one undo tablespaces available in the database

C.when the undo tablespace is of a fixed size and retention guarantee is not enabled

D.when the undo tablespace is autoextensible and retention guarantee is not enabled

Answer: C

答案解析：

此题考的是UNDO_RETENTION 即使设置了值，在哪些情况下会忽略。

在固定大小的还原表空间，且没有设置retention guarantee 强制保留，UNDO_RETENTION 就会被忽略。如果设置了retention guarantee ，即使是固定大小的表空间，也不会忽略UNDO_RETENTION，但有可能出现事务失败。