This preview shows page 1. Sign up to view the full content.
Unformatted text preview: e tables are locked to prevent DML operations with tables.
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
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
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 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.
B: This command will not enable restricted sessi...
View Full Document
This document was uploaded on 03/08/2014.
- Fall '09