During the direct load in sqlloader the data can be

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: e 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. Actualtests.com - The Power of Knowing 1Z0-023 Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 531-534 Chapter 11: Data Loads and National Language Support QUESTION 150: How can DBA enable restricted sessions at startup? A. SQL> STARTUP RESTRICT; B. SQL> STARTUP DISABLE SESSION; C. SQL> STARTUP ENABLE RESTRICTED SESSION; D. SQL> ALTER SYSTEM ENABLE RESTRICTED SESSION; Answer: A 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 sessi...
View Full Document

This document was uploaded on 03/08/2014.

Ask a homework question - tutors are online