Temporary tablespace cannot hold permanent objects by

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: ermanent objects by definition. Incorrect Answers: A: Temporary tablespace is used exactly for sorts, which cannot be done in memory. B: Temporary tablespace cannot hold any permanent objects. Data dictionary information usually is stored in SYSTEM tablespace. D: Temporary tablespace have nothing to do with buffer cache, it is used for sorts. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 344-345 Chapter 7: Managing the Physical Database Structure QUESTION 59: Which statement about segments is true? A. They can have zero extents. B. They can span multiple data files. C. They can span multiple tablespaces. D. They can belong to more than on table. Answer: B Explanation: Answer B is correct. Segments can span multiple data files. Incorrect Answers: A: Each segment needs to have at least one extent, not zero. C: Segments cannot span multiple tablespaces, only data files. D: Each segment belongs to one table. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 345-348 Chapter 7: Ma...
View Full Document

Ask a homework question - tutors are online