This preview shows page 1. Sign up to view the full content.
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.
Row overflow area is used during creating index-organized tables to keep the B-tree structure
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
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.
Inserts are inexpensive for undo changes because only the new ROWID must be stored.
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
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
'Day_oltp' line specifies the resource plan.
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
- Fall '09