Incorrect answers b set pctfree high if rows in your

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: 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 QUESTION 5: 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. Answer: D Explanation: Checkpoints will take longer after increasing the value of the FAST_START_IO_TARGET parameter. Incorrect Answers: 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 QUESTION 6: When a deadlock shutdown is detected by Oracle, where is the trace file generated? A. SQL_TRACE B. TRACE_DEST C. USER_DUMP_DEST D. CORE_DUMP_DEST E. BACKGROUND_DUMP_DEST - The Power of Knowing 1Z0-024 Answer: C Explanation: 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 USER_DUMP_DEST. Incorrect Answers: 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 QUESTION 7: If a willing-to-wait latch request is satisfied on the first attempt, which statistic gets incremented?...
View Full Document

This document was uploaded on 03/08/2014.

Ask a homework question - tutors are online