READ Free Dumps For Oracle- 1z0-023
| Question ID 8908 | In which two cases do you need to perform a conventional path load? (Choose two)
|
| Option A | When clustered tables must be loaded.
|
| Option B | When you need to reorganize the database tables.
|
| Option C | When the load should not generate redo log entries.
|
| Option D | When the data should be loaded as fast as possible.
|
| Option E | When transactions must make changes the tables being loaded.
|
| Correct Answer | AE |
Explanation Explanation/Reference: Explanation: Answers A and E are correct. To make changes to the tables being loaded and load clustered tables you need perform a conventional path load, not direct load. During conventional path loads: 1. COMMITs are used to make changes permanent. 2. Redo log entries are always generated. 3. All enabled constraints are enforced. 4. INSERT triggers fire. 5. Clustered tables can be loaded. 6. Other users can make changes to the tables being loaded. Incorrect Answers: B: You cannot reorganize the database tables by using conventional path load. C: Conventional path load will generate redo log entries by definition. D: When the data should be loaded as fast as possible, use direct path load, not conventional one. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 531-534 Chapter 11: Data Loads and National Language Support
| Question ID 8909 | Which SQL statement allows direct path loads?
|
| Option A | INSERT INTO...SELECT
|
| Option B | INSERT /*+DIRECT*/...
|
| Option C | UPDATE /*+DIRECT*/...
|
| Option D | INSERT INTO...VALUES...
|
| Correct Answer | B |
Explanation Explanation/Reference: Explanation: Answer B is correct. Statement INSERT /*+DIRECT*/... allows direct path loads. Incorrect Answers: A: This statement allows conventional path loads. C: Updates cannot be done with direct path loads. D: This statement allows conventional path loads. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 531-534 Chapter 11: Data Loads and National Language Support