READ Free Dumps For Oracle- 1z0-023
| Question ID 8827 | In which two ways can a DBA limit the size of the user trace files? (Choose two)
|
| Option A | Set the MAX_DUMP_FILE initSID.ora file
|
| Option B | Set the MAX_DUMP_FILE_SIZE in the initSID.ora file
|
| Option C | Initiate the ALTER SESSION TRUNCATE TRACE TO integer K|M command
|
| Option D | Initiate the ALTER SYSTEM SET MAX_DUMP_FILE_SIZE=integer command
|
| Correct Answer | BD |
Explanation Explanation/Reference: Explanation: 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 MAX_DUMP_FILE_SIZE=integer command. Incorrect Answers: 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
| Question ID 8828 | What is the primary function of the redo logs?
|
| Option A | To provide read consistency.
|
| Option B | To record all changes made to data.
|
| Option C | To roll back uncommitted transactions.
|
| Option D | To update datafiles of uncommitted transactions.
|
| Correct Answer | B |
Explanation Explanation/Reference: Explanation: 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. Incorrect Answers: A: Rollback segments provide read consistency. C: Rollback segments also are used to roll back uncommitted transactions. D: Redo logs do not update datafiles of uncommitted transactions. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 324-325 Chapter 7: Managing the Physical Database Structure