This preview shows page 1. Sign up to view the full content.
Unformatted text preview: ct Answers:
B: Set PCTFREE high if rows in your table will be updated often and each update will add to the
size in bytes of the row.
C: PCTFREE=20 is too high for table with static data.
D: PCTFREE=10 is too high for table with static data.
Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 350-352
Chapter 7: Managing the Physical Database Structure
Which action could potentially cause checkpoints to take longer?
A. Increasing the number of redo log groups.
B. Increasing the size of rollback segments.
C. Decreasing the value of the REDO_LOG_BUFFERS parameter.
D. Increasing the value of the FATS_START_IO_TARGET parameter.
Checkpoints will take longer after increasing the value of the FAST_START_IO_TARGET
A: Increasing the number of redo log groups will not cause checkpoints to take longer.
B: The size of rollback segments has nothing to do with checkpoint duration.
C: The value of the REDO_LOG_BUFFERS does not interact with checkpoint duration.
Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 902
Chapter 19: Tuning Disk Utilization
When a deadlock shutdown is detected by Oracle, where is the trace file generated?
E. BACKGROUND_DUMP_DEST Actualtests.com - The Power of Knowing 1Z0-024
When Oracle's deadlock detection mechanisms discover a deadlocking situation on the database,
they write a message to the ALERT log for the Oracle instance, located in
A: The trace file will not be generated in SQL_TRACE.
B: There is no TRACE_DESC location in Oracle configuration.
D: CORE_DUMP_DEST location contains files different information, not deadlocks.
E: The trace file in BACKGROUND_DUMP_DEST does not contain "a deadlock shutdown".
Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 943-945
Chapter 20: Tuning Other Areas of the Oracle Database
If a willing-to-wait latch request is satisfied on the first attempt, which statistic gets
View Full Document
This document was uploaded on 03/08/2014.
- Fall '09