READ Free Dumps For Oracle- 1z0-023
| Question ID 8910 | Which two statements about direct load in SQL *Loader are true? (Choose two)
|
| Option A | Insert triggers fire.
|
| Option B | Redo is always generated.
|
| Option C | All constraint types are enforced.
|
| Option D | The data can be loaded in parallel
|
| Option E | The tables are locked to prevent DML.
|
| Option F | Clustered tables can be used with direct loads.
|
| Correct Answer | DE |
Explanation Explanation/Reference: Explanation: Answers D and E are correct. During the direct load in SQL*Loader the data can be loaded in parallel and the tables are locked to prevent DML operations with tables. Incorrect Answers: A: Insert triggers will not fire during direct load process by definition. B: Redo log entries will not be generated during direct load process by definition. C: Only PRIMARY KEY, UNIQUE and NOT NULL constraints are enforced during direct load process. F: Clustered tables cannot be loaded with direct loads by definition. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 531-534 Chapter 11: Data Loads and National Language Support
| Question ID 8911 | How can DBA enable restricted sessions at startup?
|
| Option A | SQL> STARTUP RESTRICT;
|
| Option B | SQL> STARTUP DISABLE SESSION;
|
| Option C | SQL> STARTUP ENABLE RESTRICTED SESSION;
|
| Option D | SQL> ALTER SYSTEM ENABLE RESTRICTED SESSION;
|
| Correct Answer | A |
Explanation Explanation/Reference: Explanation: Answer A is correct. STARTUP RESTRICT command enables restricted sessions at startup. Other way to restrict database access is command ALTER SYSTEM ENABLE RESTRICTED SESSION after the database is open. Incorrect Answers: B: This command will not enable restricted sessions at startup. C: This command will not enable restricted sessions at startup. D: This command will enable restricted session, but only AFTER the database is open, not at startup. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 287-288 Chapter 6: Basics of the Oracle Database Architecture