This preview shows page 1. Sign up to view the full content.
Unformatted text preview: ON TRUNCATE TRACE TO integer K|M command
D. Initiate the ALTER SYSTEM SET MAX_DUMP_FILE_SIZE=integer command
Answer: B, D
Answers B and D are correct. You can control the size of the user trace files by settint the
MAX_DUMP_FILE_SIZE in the initSID.ora file or by changing it using ALTER SYSTEM SET
A: There is no MAX_DUMP_FILE parameter in the initSID.ora file.
C: There is no ALTER SESSION TRUNCATE TRACE TO integer K|M command.
Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 279-281
Chapter 6: basics of the Oracle Database Architecture
What is the primary function of the redo logs?
A. To provide read consistency.
B. To record all changes made to data.
C. To roll back uncommitted transactions.
D. To update datafiles of uncommitted transactions.
Answer B is correct. The redo logs are used to record all changes made to data. Each user
process that makes a change to a table must write a small record, called a redo log entry, that
identifies the change that was made.
View Full Document
- Fall '09