READ Free Dumps For Oracle- 1z0-023
| Question ID 8799 | Which two files are used by the SQL*Loader? (Choose two)
|
| Option A | Log file.
|
| Option B | Data file.
|
| Option C | Init.ora file.
|
| Option D | Password file.
|
| Option E | Background process trace file.
|
| Correct Answer | AB |
Explanation Explanation/Reference: Explanation: Answer A and B are correct. SQL *Loader uses datafile, which stores the data to be loaded, and log file, which shows you information about load errors and results. Incorrect Answers: C: SQL*Loader does nor work with Init.ora file. D: SQL*Loader have nothing to do with password file. E: SQL*Loader does not work with background process trace file. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 522-534 Chapter 11: Data Loads and National Language Support
| Question ID 8800 | Which two statements about direct load in SQL*Loader are true? (Choose two)
|
| Option A | Insert triggers do not fire.
|
| Option B | Redo for the inserts is optional.
|
| Option C | All constraint types are enforced..
|
| Option D | The data cannot be loaded in parallel.
|
| Option E | Cluster tables can be loaded using direct path loads.
|
| Option F | During the load, the table data can be modifies by other users.
|
| Correct Answer | AB |
Explanation Explanation/Reference: Explanation: Answers A and B are correct. During direct load in SQL*Loader insert triggers do not fire, because no SQL INSERT commands are used and redo logs generation for the inserts are optional. Incorrect Answers: C: Not all constraints types are enforced, ONLY PRIMARY KEY and NOT NULL constraints will be enforced during direct load. D: The data can be loaded in parallel using direct load mode. E: Cluster tables can be loaded only using conventional mode, not direct load. F: During the load the table data cannot be modified by other users. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 531-534 Chapter 11: Data Loads and National Language Support