Choose two actualtestscom the power of knowing 1z0

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

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 Explanation: 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 reached. Incorrect Answers: 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 QUESTION 111: Which two data dictionary views would you query to investigate space usage in a tablespace? (Choose two) A. DBA_TABLES B. DBA_EXTENTS C. DBA_TABLESPACE D. DBA_FREE_SPACE E. DBA_SPACE_USAGE Answer: C, D Explanation: Answers C and D are correct. Dictionary views DBA_TABLESPACES and DBA_FREE_SP...
View Full Document

Ask a homework question - tutors are online