C speed up full table scans and fast full index scans

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: p the b-tree structure densely clustered. C. Speed up full table scans and fast full index scans. Actualtests.com - The Power of Knowing 1Z0-024 D. Improve performance when the index-organized table is clustered. Answer: B Explanation: Row overflow area is used during creating index-organized tables to keep the B-tree structure densely clustered. Incorrect Answers: A: Row overflow is not used to avoid row chaining and migration. For these problems you need to update PCTFREE parameter or use ANALYZE command. C: This area will not help you to speed up full table scans and fast full index scans. D: Index-organized table cannot be clustered. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 791-793. Chapter 17: Tuning Database Application QUESTION 41: Which statement about the amount of undo generated is true? A. The amount is the same for any DML operation. B. Deletes are inexpensive, because only the ROWID must be stored. C. Inserts are inexpensive, because only the ROWID must be stored. D. Update are inexpensive, because only the new column value must be stored. Answer: C Explanation: Inserts are inexpensive for undo changes because only the new ROWID must be stored. Incorrect Answers: A: The amount of generated is different for different DML operations. B: For deletes not only ROWID of deleted rows must be stored in generated undo. D: For updates not only the new, but old value for column must be also stored. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 904-911. Chapter 19: Tuning Disk Utilization QUESTION 42: You just created a resource plan and placed this line in the init.ora RESOURCE_MANAGER_PLAN = day_oltp What does 'day_oltp' specify? A. Resource plan. B. Plan directive. C. Consumer group. D. Resource manager privilege. Actualtests.com - The Power of Knowing 1Z0-024 Answer: A Explanation: 'Day_oltp' line specifies the resource plan. Incorrect Answers: B: This line does not specify plan directive. C: RESOURCE_MANAGER_PLAN parameter does not specify consumer group. D: Resource manager privilege is not related with RE...
View Full Document

Ask a homework question - tutors are online