B a locally managed permanent tablespace c a

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: managed permanent tablespace. C. A dictionary-managed temporary tablespace. D. A dictionary-managed permanent tablespace. Answer: A Explanation: 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. Incorrect Answers: 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 tablespace. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 1146 Chapter 24: Oracle8i New Features Topics QUESTION 70: Which two statements about tempfiles are true? (Choose two) A. Media recovery does not recover tempfiles. B. Tempfiles c...
View Full Document

Ask a homework question - tutors are online