This preview shows page 1. Sign up to view the full content.
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
- Fall '09