A full b direct c compact d compress answer d

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: FULL B. DIRECT C. COMPACT D. COMPRESS Answer: D Explanation: 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 later. Incorrect Answers: 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 QUESTION 3: What are two reasons for changing user quotas on a tablespace? (Ch...
View Full Document

{[ snackBarMessage ]}

Ask a homework question - tutors are online