The parallel direct load insert uses parallel query

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: t uses parallel query slaves to insert the data. The data is written to temporary segments until the transaction commits. Incorrect Answers: B: Query slaves, not the server process, insert the rows into temporary segments. C: Temporary segments will be converted into table extents, not copied into existing table extents. D: Temporary segments will be converted into table extents, not copied into existing table extents. Also query slaves, not the server process, insert the rows into temporary segments. E: Query slave are not assigned a range of blocks that are already part of the table: they insert directly into temporary segments, which are converted to extents. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 531-534 Chapter 11: Data Loads and National Language Support QUESTION 56: Which two methods increase the size of a tablespace? (Choose two) A. Add a datafile to a tablespace. B. Increase the size of a datafile in the tablespace. C. Use the ALTER TABLESPACE command to increase the MINEXTENTS for the tablespace. D. Use the ALTER TABLESPACE co...
View Full Document

Ask a homework question - tutors are online