READ Free Dumps For Oracle- 1z0-023
| Question ID 8801 | How does oracle perform direct-load insert in parallel?
|
| Option A | Query slaves insert the rows into temporary segments, which are converted to extents.
|
| Option B | The server process inserts the rows into temporary segments, which are converted to extents.
|
| Option C | Query slaves insert the rows into temporary segments, which are copied into existing table extents.
|
| Option D | The server process inserts the rows into temporary segments, which are copied into existing table extents.
|
| Option E | Query slave are assigned a range of blocks that are already part of the table and inserted into their assigned blocks.
|
| Correct Answer | A |
Explanation Explanation/Reference: 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 insert 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 ID 8802 | Which two methods increase the size of a tablespace? (Choose two)
|
| Option A | Add a datafile to a tablespace.
|
| Option B | Increase the size of a datafile in the tablespace.
|
| Option C | Use the ALTER TABLESPACE command to increase the MINEXTENTS for the tablespace.
|
| Option D | Use the ALTER TABLESPACE command to increase the MAXEXTENTS for the tablespace.
|
| Option E | Use the ALTER TABLESPACE command to increase the MINIMUM EXTENT for the tablespace.
|
| Correct Answer | AB |
Explanation Explanation/Reference: Explanation: Answers A and B are correct. You can add a datafile to a tablespace or just increase the size of a datafile in the tablespace to increase the size of a tablespace. Incorrect Answers: C: By increasing the MINEXTENTS parameter for the tablespace you cannot increase the size of tablespace. D: By increasing the MAXEXTENTS parameter for the tablespace you cannot increase the size of tablespace. E: There is no MINIMUM EXTENT clause in ALTER TABLESPACE command. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 339-340 Chapter 7: Managing the Physical Database Structure