Unformatted text preview: managed permanent tablespace.
C. A dictionary-managed temporary tablespace.
D. A dictionary-managed permanent tablespace.
Answer A is correct. You need to use temporary tablespace for large sort operations. If you also
want to reduce contention on data dictionary tables, you need to use locally managed tablespace.
B: For sort you need temporary tablespace, not permanent.
C: To reduce contention on data dictionary tables, you need to use locally managed tablespace,
Actualtests.com - The Power of Knowing 1Z0-023
not dictionary-managed tablespace.
D: To reduce contention on data dictionary tables and for large sort operations, you need to use
locally managed tablespace temporary tablespace, not dictionary-managed permanent
Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 1146
Chapter 24: Oracle8i New Features Topics
Which two statements about tempfiles are true? (Choose two)
A. Media recovery does not recover tempfiles.
B. Tempfiles c...
View Full Document
This document was uploaded on 03/08/2014.
- Fall '09