This preview shows page 1. Sign up to view the full content.
Unformatted text preview: ermanent objects by definition.
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
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 is correct. Segments can span multiple data files.
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
- Fall '09