This preview shows page 1. Sign up to view the full content.
Unformatted text preview: owing 1Z0-023
A. There are no rollback segments online.
B. There is no room in the tablespace for the rollback segment to extend.
C. MAXEXTENTS has been reached, preventing the segment from extending.
D. The maximum number of user per rollback segment has been exceeded.
Answer: B, C
Answers B and C are correct. If an ORA-01562 error is happened, it's two possibilities: there is
no room in the tablespace for the rollback segment to grow or MAXEXTENTS has been
A: To receive this error you need to have rollback segment online.
D: There is no the maximum number of user per rollback segment value in Oracle.
Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 380-381
Chapter 8: Managing Database Objects I
Which two data dictionary views would you query to investigate space usage in a
tablespace? (Choose two)
Answer: C, D
Answers C and D are correct. Dictionary views DBA_TABLESPACES and
View Full Document
- Fall '09