This preview shows page 1. Sign up to view the full content.
Unformatted text preview: (USER_ID). Where should USERS and USERID_NDX
Actualtests.com - The Power of Knowing 1Z0-024 A. Same tablespace.
B. SYSTEM tablespace.
C. Same tablespace on different disks.
D. Different tablespace on different disks.
For better performance the USERS table and the USERID_NDX index must be stored in
different tablespaces on different disks.
A: If these objects will be in the same tablespace it will cause performance degradation.
B: SYSTEM tablespace is used to store only data dictionary objects, not for user tables or
C: It's not recommended to put data and index data in one tablespace: it will cause I/O
contention, because Oracle will try to retrieve index and data blocks from one tablespace in one
Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 844.
Chapter 18: Tuning Memory and Operating System Use
You are creating a new rollback segment. Why should you choose the same value for the
NEXT and INITIAL attributes?
A. That depends on the PCTINCREASE value you specify.
B. To avoid contention on the
rollback segment header.
C. Rollback segment extents are used in a circular way.
D. Because you get an error message if you specify different values.
Rollback segment extents are used in a circular way, so the NEXT and INITIAL
attributes are the same for rollback segment.
A: PCTINCREASE parameter for rollback segments is zero always.
B: Value for the NEXT and INITIAL attributes are the same for the rollback segment, it does not
relate with contention on the rollback segment header.
D: You should choose the same value for the NEXT and INITIAL attributes because rollback
segments extents are used in a circular way, not because of error message.
Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 904-911.
Chapter 19: Tuning Disk Utilization Actualtests.com - The Power of Knowing 1Z0-024
What should be your main redo log buffer tuning goal?
View Full Document
This document was uploaded on 03/08/2014.
- Fall '09