AllExam Dumps

DUMPS, FREE DUMPS, VCP5 DUMPS| VMWARE DUMPS, VCP DUMPS, VCP4 DUMPS, VCAP DUMPS, VCDX DUMPS, CISCO DUMPS, CCNA, CCNA DUMPS, CCNP DUMPS, CCIE DUMPS, ITIL, EXIN DUMPS,


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

Send email to admin@getfreedumps for new dumps request!!!