Unformatted text preview: FULL
Answer D is correct because parameter COMPRESS=Y indicates whether EXPORT will place
all rows of the table into one initial extent in the export file. This is useful for reducing
fragmentation, but you may allocate too much space if your table has a lots of deleted rows. It is
important to note here that Oracle does not actually reduce space use; it merely recalculates the
existing data so that it fits into one big initial segment, which can still cause space problems
A: Parameter FULL=Y indicates whether EXPORT should export the entire database.
B. Parameter DIRECT=Y allows user to run faster exports using the direct path. This is similar
Actualtests.com - The Power of Knowing 1Z0-023
in function to direct-path loading in SQL*Loader.
C: Parameter COMPACT does not exist.
Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 534-536
Chapter 1: Selecting Data from Oracle
What are two reasons for changing user quotas on a tablespace? (Ch...
View Full Document
- Fall '09
- Oracle Database, Jason S. Couchman, DBA Certification Exam, Certification Exam Guide