Actualtestscom the power of knowing 1z0 023 oracle 8

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: f Knowing 1Z0-023 Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 531-534 Chapter 11: Data Loads and National Language Support QUESTION 55: How does oracle perform direct-load insert in parallel? A. Query slaves insert the rows into temporary segments, which are converted to extents. B. The server process inserts the rows into temporary segments, which are converted to extents. C. Query slaves insert the rows into temporary segments, which are copied into existing table extents. D. The server process inserts the rows into temporary segments, which are copied into existing table extents. E. Query slave are assigned a range of blocks that are already part of the table and inserted into their assigned blocks. Answer: A Explanation: Answer A is correct. To insert data in parallel query slaves insert the rows into temporary segments, which are converted to extents later. To perform a parallel direct-load insert, use the PARALLEL hint in the INSERT INTO SELECT command. The parallel direct-load inser...
View Full Document

This document was uploaded on 03/08/2014.

Ask a homework question - tutors are online